SQL search multiple values in same field

by

Yes, you can use SQL IN operator to search multiple absolute values:

SELECT name FROM products WHERE name IN ( 'Value1', 'Value2', ... );

If you want to use LIKE you will need to use OR instead:

SELECT name FROM products WHERE name LIKE '%Value1' OR name LIKE '%Value2';

Using AND (as you tried) requires ALL conditions to be true, using OR requires at least one to be true.

More Related Contents:

  1. Implementation of Levenshtein distance for mysql/fuzzy search?
  2. MySQL find_in_set with multiple search string
  3. MySQL search and replace some text in a field
  4. Search for string within text column in MySQL
  5. Search all columns of a table using a single where condition with single keyword in mysql
  6. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  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. how to delete data from table A besides the customer service and director data in table B?
  11. Get records with max value for each group of grouped SQL results
  12. How to store multiple options in a single table?
  13. How to populate a table with a range of dates?
  14. Get the new record primary key ID from MySQL insert query?
  15. brew install mysql on macOS
  16. TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes
  17. How do I check to see if a value is an integer in MySQL?
  18. Add 2 hours to current time in MySQL?
  19. Store image to database blob; retrieve from db into Picturebox
  20. MySQL trigger On Insert/Update events
  21. MySQL combine two columns into one column
  22. How to get first day of every corresponding month in mysql?
  23. How can I change MariaDB to MySQL in XAMPP?
  24. MySQL: LIMIT by a percentage of the amount of records?
  25. Select a column with a keyword name
  26. Sum results of a few queries and then find top 5 in SQL
  27. ERROR 1356 (HY000): View ‘mysql.user’ references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
  28. Use Composite Primary Key as Foreign Key
  29. Detecting utf8 broken characters in MySQL
  30. django cannot connect mysql in docker-compose

Leave a Comment