How to implement a Keyword Search in MySQL?

by

For a single keyword on VARCHAR fields you can use LIKE:

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)

For a description you’re usually better adding a full text index and doing a Full-Text Search (MyISAM only):

SELECT id, description
FROM table
WHERE MATCH (description) AGAINST('keyword1 keyword2')

More Related Contents:

  1. Fulltext Search with InnoDB
  2. Which SQL query is better, MATCH AGAINST or LIKE?
  3. VARCHAR as foreign key/primary key in database good or bad?
  4. MySQL LIKE IN()?
  5. In MySQL queries, why use join instead of where?
  6. Why would an IN condition be slower than “=” in sql?
  7. PostgreSQL GROUP BY different from MySQL?
  8. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  9. Stored Procedure with optional “WHERE” parameters
  10. MySQL dump by query
  11. SQLite – ORDER BY RAND()
  12. Delete sql rows where IDs do not have a match from another table
  13. How to search multiple columns in MySQL?
  14. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  15. What does DELIMITER // do in a Trigger?
  16. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  17. SQL Between clause with strings columns
  18. MySQL equivalent of DECODE function in Oracle
  19. How do you version your database schema? [closed]
  20. Can a stored procedure/function return a table?
  21. MySQL, Get users rank
  22. Mysql: how to select groups having certain values?
  23. How to fill date gaps in MySQL?
  24. Boolean vs tinyint(1) for boolean values in MySQL
  25. MySQL: “The SELECT would examine more than MAX_JOIN_SIZE rows”
  26. Function for week of the month in mysql
  27. MySQL’s alternative to T-SQL’s WITH TIES
  28. Find rows that have the same value on a column in MySQL
  29. what is the difference between GROUP BY and ORDER BY in sql
  30. Hamming Distance / Similarity searches in a database

Leave a Comment