MySQL搜索查询两列 [英] Mysql search query two columns

问题描述

我正在为我的网站建立搜索功能，并希望按标题和作者两列进行搜索.

I'm bulding a search function for my web site and wish to search by two columns: title and author.

查询:

SELECT title, bookID, publisher, pubDate, book_image, books.authorID, authors.author FROM books, authors WHERE books.authorID = authors.authorID 
            AND title LIKE '$queryString%' OR author LIKE '$queryString%'LIMIT 5

当我按标题搜索时，这很好用，但是当我按作者搜索时，我得到了所有书籍的列表，其中所搜索的作者为作者.显然这是不正确的.

When I search by title this works fine, but when I search by author I get a list of all books with the searched for author as author. Obviously this is incorrect.

如何解决此查询以成功搜索标题或作者?

How can I fix this query to successfully search for either title or author?

推荐答案

尝试以下方法:

SELECT title, bookID, publisher, pubDate, book_image, books.authorID, authors.author 
FROM books left join  authors on  books.authorID = authors.authorID 
WHERE (title LIKE '$queryString%' OR author LIKE '$queryString%') LIMIT 5

我建议您在mysql中使用 全文 搜索.会更快，更有效

I would like to suggest you to use fulltext search in mysql.That will be more faster and efficient

这篇关于MySQL搜索查询两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！