phpcms mysql使用like查询关键词
文章描述：
phpcms mysql使用like查询文件里面的内容
SELECT a.id, a.title, c.catname, a.keywords, a.description, b.content
FROM v9_news AS a
LEFT JOIN v9_news_data AS b ON a.id = b.id
LEFT JOIN v9_category AS c ON a.catid = c.catid
WHERE
a.title LIKE '%2012%' OR
a.description LIKE '%2012%' OR
b.content LIKE '%2012%'
发布时间：2022/03/25
发表评论