Форум пользователей MySQL

mysql> create table test (id int not null auto_increment primary key, city varch
ar(256));
Query OK, 0 rows affected (0.61 sec)

mysql> insert into test (city) values('орел'),('москва'),('армавир16');
Query OK, 3 rows affected (0.19 sec)
Records: 3  Duplicates: 0  Warnings: 0

mysql> select * from test;
+----+-----------+
| id | city      |
+----+-----------+
|  1 | орел      |
|  2 | москва    |
|  3 | армавир16 |
+----+-----------+
3 rows in set (0.05 sec)

mysql> select * from test order by (city='москва') desc, city asc;
+----+-----------+
| id | city      |
+----+-----------+
|  2 | москва    |
|  3 | армавир16 |
|  1 | орел      |
+----+-----------+
3 rows in set (0.00 sec)