Grant

South Africa

May
26
revised How to fetch record by month in MySQL?
added 137 characters in body
May
26
revised How to fetch record by month in MySQL?
added 181 characters in body
May
26
answered How to fetch record by month in MySQL?
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
Thanks, this also works well, I accepted the answer below as it fits my purpose better. I am using the output to a chart and getting the values in one group works better in my application.
May
24
accepted Get totals for the same column but where each SELECT alias contains a specific string
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
Great solution, thank you!
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
So if a column is NULL assign stage 3 to it
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
status_group | total : NULL = 2, stage 1 = 24, stage 2 = 15
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
Ah that is a LOT simpler. How can I fix the output if there is for example no stage 3 value.
May
24
comment Get totals for the same column but where each SELECT alias contains a specific string
status field is a VARCHAR containing text as follows this will vary: "We will implement Stage 1 from 07:00 until 22:00 this evening. "
May
24
asked Get totals for the same column but where each SELECT alias contains a specific string
May
11
awarded Popular Question
May
4
awarded Notable Question
Apr
18
awarded Constituent
Apr
14
awarded Caucus
Mar
26
revised Get ddSlick selected items to dynamically add to default total on page
added 15 characters in body
Mar
26
revised Get ddSlick selected items to dynamically add to default total on page
deleted 1 character in body
Mar
26
revised Get ddSlick selected items to dynamically add to default total on page
added 189 characters in body
Mar
26
revised Get ddSlick selected items to dynamically add to default total on page
added 2 characters in body
Mar
26
asked Get ddSlick selected items to dynamically add to default total on page
1 2 3 4 5