How to search multiple columns in MySQL?

by

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.

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

More Related Contents:

  1. Fulltext Search with InnoDB
  2. MySQL full text search for words with three or less letters
  3. Any way to achieve fulltext-like search on InnoDB
  4. INNER JOIN ON vs WHERE clause
  5. How to SELECT the newest four items per category?
  6. MySQL: Alternatives to ORDER BY RAND()
  7. MySQL LIKE IN()?
  8. Auto Increment after delete in MySQL
  9. In MySQL queries, why use join instead of where?
  10. Stored Procedure with optional “WHERE” parameters
  11. SQLite – ORDER BY RAND()
  12. MySQL syntax for Join Update
  13. How to delete Duplicates in MySQL table
  14. Selecting Random Rows in MySQL
  15. SQL SELECT to get the first N positive integers
  16. Sorting string column containing numbers in SQL?
  17. Error: The used SELECT statements have a different number of columns
  18. Multiple Ranks in one table
  19. The difference between ‘AND’ and ‘&&’ in SQL
  20. How can I make an average of dates in MySQL?
  21. How to combine aggregate functions in MySQL?
  22. What is the best way to generate ranks in MYSQL?
  23. How do I list all the columns in a table?
  24. Two single-column indexes vs one two-column index in MySQL?
  25. VARCHAR as foreign key/primary key in database good or bad?
  26. MySQL SELECT x FROM a WHERE NOT IN ( SELECT x FROM b ) – Unexpected result
  27. How do I create a table alias in MySQL
  28. MySql bulk load command line tool
  29. ALTER TABLE without locking the table?
  30. MySQL: Typecasting NULL to 0

Leave a Comment