V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
推荐工具
› RoboMongo
推荐书目
› 50 Tips and Tricks for MongoDB Developers
Related Blogs
› Snail in a Turtleneck
This topic created in 3348 days ago, the information mentioned may be changed or developed.
SELECT *,
( IF(LOCATE('腾讯', title), 4, 0) + IF(LOCATE('腾讯', content), 2, 0) + IF(LOCATE('逆市', title), 4, 0) + IF(LOCATE('逆市', content), 2, 0) ) AS score
FROM s_data
WHERE ( (title LIKE '%腾讯%') OR (content LIKE '%腾讯%') OR (title LIKE '%逆市%') OR (content LIKE '%逆市%') )
ORDER BY score DESC, created_at Desc LIMIT 10
( IF(LOCATE('腾讯', title), 4, 0) + IF(LOCATE('腾讯', content), 2, 0) + IF(LOCATE('逆市', title), 4, 0) + IF(LOCATE('逆市', content), 2, 0) ) AS score
FROM s_data
WHERE ( (title LIKE '%腾讯%') OR (content LIKE '%腾讯%') OR (title LIKE '%逆市%') OR (content LIKE '%逆市%') )
ORDER BY score DESC, created_at Desc LIMIT 10
 |
1
li35619081 Mar 31, 2017
可是 可以 比较复杂而已啦。
|
Select Language