108 reputation
4
bio website
location
age
visits member for 2 years, 4 months
seen Jun 7 at 15:41

Feb
17
comment MySQL Reusing calculation in SELECT clause in a VIEW
Also thanks for the CURDATE() suggestion! Am using that now :)
Feb
17
awarded  Scholar
Feb
17
awarded  Supporter
Feb
17
accepted MySQL Reusing calculation in SELECT clause in a VIEW
Feb
17
comment MySQL Reusing calculation in SELECT clause in a VIEW
I might have to use this I think. Thanks!
Feb
16
comment MySQL Reusing calculation in SELECT clause in a VIEW
Wouldn't that have a huge performance impact?
Feb
16
revised MySQL Reusing calculation in SELECT clause in a VIEW
added 3 characters in body
Feb
16
asked MySQL Reusing calculation in SELECT clause in a VIEW
Aug
17
comment MySQL GROUP BY and ORDER BY giving inconsistent results
Oh, my bad, it seems WordPress only selects the ID of each record first, then selects each of them individually at a later stage, which also selects the date. The results were shown through PHP rather than direct MySQL output.
Aug
16
awarded  Student
Aug
16
awarded  Editor
Aug
16
comment MySQL GROUP BY and ORDER BY giving inconsistent results
Thanks for the answer. See the edits. Not quite sure what you mean with where the dates came from?
Aug
16
revised MySQL GROUP BY and ORDER BY giving inconsistent results
added 674 characters in body
Aug
16
asked MySQL GROUP BY and ORDER BY giving inconsistent results