⽤LOCATE函数
MySql多个字段关键字分词模糊查询，按照最佳匹配度排序，使⽤LOCATE函数SELECT DISTINCTt.*
FROM
pub_course t
LEFT JOIN course_tag t1 ON (t1.entitytype = t.typeAND t1.entityid = t.id)
WHEREt.ishide != 1
AND t.pubstatus = 1AND (
t. NAME LIKE '%盛放的彩铅%'OR t. NAME = '盛放的彩铅'OR t. NAME LIKE '%彩铅%'OR t. NAME = '彩铅'
OR t. NAME LIKE '%盛放%'OR t. NAME = '盛放'
OR t.createname LIKE '%盛放的彩铅%'OR t.createname = '盛放的彩铅'OR t1.tlname LIKE '%盛放的彩铅%'OR t1.tlname = '盛放的彩铅'
OR t.createname LIKE '%彩铅%'OR t.createname = '彩铅'OR t1.tlname LIKE '%彩铅%'OR t1.tlname = '彩铅'
OR t.createname LIKE '%盛放%'OR t.createname = '盛放'OR t1.tlname LIKE '%盛放%'OR t1.tlname = '盛放')
ORDER BY
LOCATE('盛放的彩铅',t.name) DESC,t.hotlevel DESC,t.score DESC,t.buynum DESC,t.pubtime DESC
因篇幅问题不能全部显示，请点此查看更多更全内容