mysql搜索，依照关键字出现的位置排序
- WBOYOriginal
- 2016-06-07 16:24:431173browse
mysql搜索，按照关键字出现的位置排序 SELECT * FROM 表 WHERE `name` LIKE '%检索值%' order by locate('检索值',name)?
mysql搜索，按照关键字出现的位置排序SELECT * FROM 表 WHERE `name` LIKE '%检索值%' order by locate('检索值',name)?
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：如何用SQL语句去掉重复记录Next article：MySQL exists的用法介绍