使用用户自定义变量

找到价格最高和最低的信息：

mysql> SELECT @min_price:=MIN(price),@max_price:=MAX(price) FROM shop;
mysql> SELECT * FROM shop WHERE price=@min_price OR price=@max_price;
+---------+--------+-------+
| article | dealer | price |
+---------+--------+-------+
|    0003 | D      |  1.25 |
|    0004 | D      | 19.95 |
+---------+--------+-------+

原文: https://strongyoung.gitbooks.io/mysql-reference-manual/content/tutorial/common_queries/using_user_defined_varibles.html