如果我在当前表中执行搜索查询,则没有问题:
SELECT * FROM文章WHERE CONCAT(标题,内容,作者)LIKE’%searchstring%’但如果我想要加入一个列……
只是在评论中写下上面提供的答案。你应该做:
SELECT articles.*, associations.name AS association_name FROM articles JOIN associations ON articles.association_id = associations.id WHERE CONCAT(title, content, author, associations.name) LIKE '%searchstring%'