56,679
社区成员
发帖
与我相关
我的任务
分享
query(
"
SELECT id, title
FROM post
WHERE (
`title` LIKE '%关键词%'
OR `content` LIKE '%关键词%'
)
LIMIT 0 , 30
"
);
select post.*,terms.name from post as a, real as b , terms as c
WHERE (
a.title LIKE '%关键词%'
OR a.content LIKE '%关键词%'
OR c.name like '%关键词%'
)
and a.id=b.postid
and b.termid=c.id