Im trying to define a variable within the MySQL interface, that can be reference within some queries. I have read the manual and stidied the syntax mentioned
(SET @var_name:=value) but MySQL reports an error '@var_name...' when I try it.

Have I got the syntax wrong or does my version (3.22.32) not support this??

I would greatly appreciate some help on this.