[sql] How to search multiple columns in MySQL?

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?

This question is related to sql mysql full-text-search

The answer is

If it is just for searching then you may be able to use CONCATENATE_WS. This would allow wild card searching. There may be performance issues depending on the size of the table.

FROM pages 
WHERE CONCAT_WS('', column1, column2, column3) LIKE '%keyword%'

Similar questions with sql tag:

Similar questions with mysql tag: