SQL

how to create a variable in mysql

-- MySQL

SET @variable_name := value;

mysql declare variable

SET start = 1;
SET finish = 10;

SELECT * FROM places WHERE place BETWEEN start AND finish;

declare variable in mysql

SET @start = 1, @finish = 10;