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 a stored procedure?
  16. Unknown column in ‘field list’ error on MySQL Update query
  17. SQL Inner-join with 3 tables?
  18. Conversion failed when converting date and/or time from character string while inserting datetime
  19. MySQL create table if not exists and insert record only if table was created
  20. error, string or binary data would be truncated when trying to insert
  21. ORA-00907: missing right parenthesis
  22. Rename column SQL Server 2008
  23. Why do we need “Relationships” between tables at all?
  24. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  25. Using group by on multiple columns
  26. Case statement in MySQL
  27. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  28. Drop a temporary table if it exists
  29. ORA-00918: column ambiguously defined in SELECT *
  30. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  31. How Stuff and ‘For Xml Path’ work in SQL Server?
  32. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  33. How do I limit the number of rows returned by an Oracle query after ordering?
  34. Oracle SELECT TOP 10 records
  35. MySQL: Invalid use of group function
  36. must appear in the GROUP BY clause or be used in an aggregate function
  37. How can I return pivot table output in MySQL?
  38. Compare dates in MySQL
  39. The multi-part identifier could not be bound
  40. MySQL syntax for Join Update
  41. Get day of week in SQL Server 2005/2008
  42. incorrect syntax error CREATE VIEW must be the only statement in the batch
  43. PLS-00103: Encountered the symbol when expecting one of the following:
  44. SQLite – UPSERT *not* INSERT or REPLACE
  45. how to drop partition without dropping data in MySQL?
  46. Simple way to calculate median with MySQL
  47. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  48. Error 1046 No database Selected, how to resolve?
  49. What is it exactly a BLOB in a DBMS context
  50. How to parse XML data in SQL server table
  51. How do you create a temporary table in an Oracle database?
  52. Oracle SQL: Update a table with data from another table
  53. How to SUM and SUBTRACT using SQL?
  54. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  55. Postgresql tables exists, but getting “relation does not exist” when querying
  56. SELECT DISTINCT on one column
  57. TSQL PIVOT MULTIPLE COLUMNS
  58. MySQL – UPDATE multiple rows with different values in one query
  59. How to create a MySQL hierarchical recursive query?
  60. Microsoft OLE DB Provider for SQL Server error ‘80004005’
  61. SQL Parentheses use in an OR clause
  62. Is it possible to GROUP BY multiple columns using MySQL?
  63. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  64. Equivalent of Oracle’s RowID in SQL Server
  65. Is there a Max function in SQL Server that takes two values like Math.Max in .NET?
  66. Best way to test if a row exists in a MySQL table
  67. Subtract one day from datetime
  68. Get current year in TSQL
  69. Is it possible to specify condition in Count()?
  70. SQL Server: Make all UPPER case to Proper Case/Title Case
  71. How do I query for all dates greater than a certain date in SQL Server?
  72. Backup a single table with its data from a database in sql server 2008
  73. updating table rows in postgres using subquery
  74. Temporary table in SQL server causing ‘ There is already an object named’ error
  75. MySQL OPTIMIZE all tables?
  76. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  77. Is there a coalesce-like function in Excel?
  78. How do I count unique items in field in Access query?
  79. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  80. MySQL LIKE IN()?
  81. Filter data based on date in sql
  82. What is a postgres superuser
  83. ora-06553 pls-306 wrong number or types of arguments in call to ‘ogc_x’
  84. SQL query to extract only the “current” wp_posts?
  85. How to retrieve sticky post in raw sql?
  86. How to remove in the wordpress database all posts revisions except the last three?
  87. Backticks (`) Instead of Single Quotes (‘) in an SQL Statement?
  88. $wpdb get_var issue
  89. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  90. Auto-update tables from database
  91. Debugging WordPress
  92. Inserting rows into a custom table, when plugin is activated
  93. dbDelta not creating table (yes, once more)
  94. Posts modified in the last 48 hours
  95. post id not displaying
  96. How to export 2 week’s worth of posts
  97. Nested select statements not working
  98. Insert multiple checkbox values
  99. How to get EVENT based on startday, using BETWEEN
  100. wpdb prepare without placeholder

Leave a Comment

techhipbettruvabetnorabahisbahis forumutaraftarium24eduedusedusedueduseduseduedusedusedu