MySQL find_in_set with multiple search string

by

there is no native function to do it, but you can achieve your aim using following trick

WHERE CONCAT(",", `setcolumn`, ",") REGEXP ",(val1|val2|val3),"

More Related Contents:

  1. Implementation of Levenshtein distance for mysql/fuzzy search?
  2. MySQL search and replace some text in a field
  3. Search for string within text column in MySQL
  4. Search all columns of a table using a single where condition with single keyword in mysql
  5. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  6. SQL search multiple values in same field
  7. Accent insensitive search query in MySQL
  8. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance
  9. How to allow fulltext searching with hyphens in the search query
  10. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  11. multiple query same table but in different columns mysql
  12. How can I make SQL case sensitive string comparison on MySQL?
  13. Import data in MySQL from a CSV file using LOAD DATA INFILE
  14. How to do a batch insert in MySQL
  15. Get current AUTO_INCREMENT value for any table
  16. Insert auto increment primary key to existing table
  17. Connect to mysql on Amazon EC2 from a remote server
  18. What is the location of mysql client “.my.cnf” in XAMPP for Windows?
  19. How to generate data in MySQL?
  20. MySQL error 1241: Operand should contain 1 column(s)
  21. MySQL – Supertype/Subtype design
  22. Case Sensitive collation in MySQL
  23. Mysql: Order by like?
  24. Getting first day of the week in MySql using Week No
  25. Can’t import database through phpmyadmin file size too large
  26. How to change MySQL column definition?
  27. MySQL : how to remove double or more spaces from a string?
  28. is php sort better than mysql “order by”?
  29. Mysql returning clause equivalent
  30. Mysql stored procedure don’t take table name as parameter

Leave a Comment