SQL variables

[riluve]

I want to declare some variable and use it a few times in a query e.g.

x = 30

SELECT count(*)
FROM table
WHERE field > x

 

[johnwm]

MySQL documentation is quite good for this sort of question:

http://dev.mysql.com/doc/refman/4.1/en/user-variables.html

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller

 

[riluve]

LOL - thank you very much, but actually I dont find it as useful as one might think. It is especially lacking in actual examples and mis leading information (e.g. appearently LN(x) doesn't work and neither does LOG(x1,x2) - ONLY log(x1) really works!). So yeah after a day with finding errors in it I am not to happy looking at it.

AND after spending almost and hour tying to figure out and being misled by DEFINE - I couldn't find the proper alternative (thank you for showing me SET!). I agree, if I knew the answer it would have been easy to find, but I didn't know the answer which is why i broke down and asked!