非常实用的查询需求，这样的SQL 怎么写？？

Question

Book表结构：book(id(int,key),title(varchar(50)),content(varchar(500)))要求查询：title或content中包含 字符串'china'的记录集合，并要求符合title的记录集排在前面，符合content条件的记录排在后面。

Answer 1

select * from book where title like '%china%'

union

select * from book where content like '%china%'

Answer 2

select * from book where charindex('china',title)>0

union all

select * from book where charindex('china',content)>0