How do I query on a self-defined variable? Example:
SELECT *, MID(dateandtime, 12, 2) as 'xxx'
FROM xyz
WHERE year = '18-19'
AND xxx > 18
Is there a way to use xxx in the query like in the last line of the example?
Asked
Active
Viewed 14 times
0
nemja
- 459
- 4
- 19
-
1Use the HAVING clause. – Paul Spiegel Feb 25 '19 at 14:46
-
You are right! Searched for that, but could not find it. Therefore the question. – nemja Feb 25 '19 at 14:48
-
@RiggsFolly single quotes work just fine for column aliases. Though I wouldn't do that. – Paul Spiegel Feb 25 '19 at 14:53
-
@PaulSpiegel Woops, I learn something every day. Never even tried to do that so sorry – RiggsFolly Feb 25 '19 at 14:54
-
@RiggsFolly You will probably only find it debugging beginner code. So you missed nothing important :-) – Paul Spiegel Feb 25 '19 at 14:56