查询:
select title from gamelist where match (title) against ('super mario luigi');
返回值:
+-----------------------------------+
| title |
+-----------------------------------+
| Super Mario and Luigi |
| Super Mario Luigi: Inside Story |
| New Super Mario Bros. |
| Mario and Luigi: Partners In Time |
| Luigi: Mansion |
+-----------------------------------+
5 rows in set (0.00 sec)
超级马里奥·路易吉(Super Mario Luigi):《超级马里奥》和《路易吉》之前应该有《内幕》。我究竟做错了什么?
谢谢!
最佳答案
您没有指定结果的排序方式。在这种情况下,返回的结果顺序是不确定的。根据您的情况添加一个明确的ORDER BY
(如果我理解正确的话)
select title from gamelist where match (title) against ('super mario luigi')
order by title DESC;
关于mysql - MySQL查询按1排序?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/5654677/