How to search multiple columns in MySQL?

Posted by George on Stack Overflow See other posts from Stack Overflow or by George
Published on 2010-03-25T10:08:14Z Indexed on 2010/03/25 10:13 UTC
Read the original article Hit count: 255

Filed under:

I'm trying to make a search feature that will search multiple columns to find a keyword based match. This query:

SELECT title FROM pages LIKE %$query%;

works only for searching one column, I noticed separating column names with commas results in an error. So is it possible to search multiple columns in mysql?

© Stack Overflow or respective owner

Related posts about mysql