Write 1SQL statements

Write an SQL statement
This post was last edited by xuz0917 on 2013-04-14 15:29:26

Table Company
ID City Top
1 Beijing, Shanghai, China
2 Jinan, Shijiazhuang, Jinan
3 Beijing Beijing

Sorting rules:
1, search "Beijing" List of ' city ' in the "Beijing";
2, ' top ' has "Beijing's front";
3. ' ID ' from large to small array sqlmysqlsql sort php

------Solution--------------------

SELECT * FROM company where city like '% Beijing% ' and top like ' Beijing ' ORDER by id DESC Union SELECT * from company where City Lik E '% Beijing% ' and top not like ' Beijing ' ORDER by id DESC
------Solution--------------------

------Solution--------------------
Try this, the test can

SELECT *
From Test
WHERE city like '% Beijing '
ORDER by (
Top like '% Beijing '
) desc, id desc

