How to declare a variable in MySQL for a normal query?

mysql, variable-declaration, variables

Solution

You can declare a session variable in this way :

SET @myvarname := 'value';

or a local variable in this way :

DECLARE my_variable varchar(30)

also:

DECLARE my_variable varchar(30) DEFAULT 'value'

Problem

How can I declare a variable for a normal query in MySQL? e.g., ``` declare @myVar date; set @myVar = something; select * from someTable where someColumn = @myVar; ``` I tried and the syntax seems to be wrong...what am I missing?

Original source