SQL SELECT WHERE field contains words

Rather slow, but working method to include any of words:

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
   OR column1 LIKE '%word2%'
   OR column1 LIKE '%word3%'

If you need all words to be present, use this:

SELECT * FROM mytable
WHERE column1 LIKE '%word1%'
  AND column1 LIKE '%word2%'
  AND column1 LIKE '%word3%'

If you want something faster, you need to look into full text search, and this is very specific for each database type.

Related Posts:

  1. How do I UPDATE from a SELECT in SQL Server?
  2. SQL SELECT WHERE field contains words
  3. SQL SELECT WHERE field contains words
  4. ORA-01843 not a valid month- Comparing Dates
  5. Best way to do nested case statement logic in SQL Server
  6. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  7. SQL: Two select statements in one query
  8. SQL conditional SELECT
  9. DATEDIFF function in Oracle
  10. MySQL error: Unknown column in ‘where clause’
  11. Postgresql column reference “id” is ambiguous
  12. How to order by column A and then by column B?
  13. Help me SELECT thumbnail from SQL and use
  14. how to SELECT meta values that are not null?
  15. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  16. Case in Select Statement
  17. What is SELF JOIN and when would you use it? [duplicate]
  18. Self Join to get employee manager name
  19. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  20. Online SQL Query Syntax Checker
  21. Must declare the scalar variable
  22. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  23. MySQL query String contains
  24. IDENTITY_INSERT is set to OFF – How to turn it ON?
  25. How to reset AUTO_INCREMENT in MySQL
  26. mysql Foreign key constraint is incorrectly formed error
  27. Can a foreign key be NULL and/or duplicate?
  28. Why does NULL = NULL evaluate to false in SQL server
  29. How do composite indexes work?
  30. Difference between one-to-many and many-to-one relationship
  31. Sql query – getting rid of hard-coded values
  32. ORA-00918: column ambiguously defined in SELECT *
  33. ORA-00918: column ambiguously defined in SELECT *
  34. How To Run A Github Repository?
  35. How do I format date and time on ssrs report?
  36. SQL Switch/Case in ‘where’ clause
  37. missing FROM-clause entry for table
  38. MySQL Error 1264: out of range value for column
  39. SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
  40. How to parse XML data in SQL server table
  41. Remote table-Valued Function Calls are not allowed
  42. Determine ROW that caused “unexpected end of file” error in BULK INSERT?
  43. Sql query to insert datetime in SQL Server
  44. Exclude a column using SELECT * [except columnA] FROM tableA?
  45. Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
  46. SQL selecting rows by most recent date with two unique columns
  47. Why is SQL server throwing this error: Cannot insert the value NULL into column ‘id’?
  48. pg_ctl: no database directory specified and environment variable PGDATA unset
  49. Postgres Error: More than one row returned by a subquery used as an expression
  50. ERROR 1148: The used command is not allowed with this MySQL version
  51. Comparing Dates in Oracle SQL
  52. How to divide two columns?
  53. MySQL starts with searching issue
  54. SQL “select where not in subquery” returns no results
  55. ListAGG in SQLSERVER
  56. The used SELECT statements have a different number of columns
  57. ‘CREATE PROCEDURE’ must be the only statement in the batch (Erro)
  58. using sql count in a case statement
  59. Oracle: If Table Exists
  60. Equivalent of explode() to work with strings in MySQL
  61. How to calculate age (in years) based on Date of Birth and getDate()
  62. How to create id with AUTO_INCREMENT on Oracle?
  63. Solutions for INSERT OR UPDATE on SQL Server
  64. Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
  65. How can I group by date time column without taking time into consideration
  66. What is the difference between Views and Materialized Views in Oracle?
  67. Append table to an existing one: SQL Server
  68. SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
  69. CASE IN statement with multiple values
  70. Update query using Subquery in Sql Server
  71. List of special characters for SQL LIKE clause
  72. “This SqlTransaction has completed; it is no longer usable.”… configuration error?
  73. Use wpdb->prepare for `order by` column name
  74. register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
  75. prepare() not working
  76. How do I move a WordPress site to another server?
  77. Return number of items in a table with post id
  78. Cron While Editing Post
  79. Debugging WordPress
  80. Pull data and display as rows and columns
  81. Export SQL query based on post type
  82. Convert a category of posts to a custom post type using (MySQL) queries
  83. I need a SQL command to delete specific authors and all posts connected with them
  84. Connect to Ms SQL Server
  85. How can i restore only Blogs from a SQL backup file?
  86. DB_HOST – is LOCALHOST speedy than domain name? [closed]
  87. REGEXP_REPLACE in post_contet
  88. How to change post published date to today date with SQL
  89. Menu Order updating automatically
  90. Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
  91. How delete post_content records of specific category from phpmyadmin
  92. Fastest way to display 5000 post titles?
  93. How do I display SQL query on a specific page of my wordpress site
  94. How to handle my row actions on a custom list table in the admin section
  95. blank page after update my theme
  96. Sql query returns empty. But not
  97. How can I avoid duplicate primary keys in SQL import?
  98. SQL – JOIN last child
  99. Adding profile data to database
  100. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1

Leave a Comment

tech