Search for “whole word match” in MySQL

by

You can use REGEXP and the [[:<:]] and [[:>:]] word-boundary markers:

SELECT *
FROM table 
WHERE keywords REGEXP '[[:<:]]rid[[:>:]]'

Update for 2020: (actually 2018+)

MySQL updated its RegExp-Engine in version 8.0.4, so you will now need to use the “standard” word boundary marker \b:

SELECT *
FROM table 
WHERE keywords REGEXP '\\brid\\b'

Also be aware that you need to escape the backslash by putting a second backslash.

More Related Contents:

  1. SQL Query needed for fetch value from Two identical table but not fully identical table
  2. SQL select only rows with max value on a column [duplicate]
  3. How to create a MySQL hierarchical recursive query?
  4. How to reset AUTO_INCREMENT in MySQL
  5. How to declare a variable in MySQL?
  6. MySQL Query GROUP BY day / month / year
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. SQL counting all rows instead of counting individual rows
  9. Can a table field contain a hyphen?
  10. How do I use on delete cascade in mysql?
  11. mysql fulltext search failure
  12. Adding a leading zero to some values in column in MySQL
  13. Using SQL to determine word count stats of a text field
  14. Update one MySQL table with values from another
  15. MySQL JOIN the most recent row only?
  16. How to transpose mysql table rows into columns
  17. MySQL Group By and Sum total value of other column
  18. MySQL incorrect key file for tmp table when making multiple joins
  19. What does SQL clause “GROUP BY 1” mean?
  20. Syntax error when using except in a query
  21. MySQL query, MAX() + GROUP BY
  22. ALTER table – adding AUTOINCREMENT in MySQL
  23. sql like operator on integer
  24. MySQL – SELECT * INTO OUTFILE LOCAL ?
  25. The best way to remove value from SET field?
  26. MySQL OPTIMIZE all tables?
  27. Strip last two characters of a column in MySQL
  28. What happens when I exhaust a bigint generated key? How to handle it?
  29. is there a length limit to group_concat or another reason why it would not work on a text field
  30. Deleting a row based on the max value

Leave a Comment