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:
- How do I UPDATE from a SELECT in SQL Server?
- SQL SELECT WHERE field contains words
- SQL SELECT WHERE field contains words
- ORA-01843 not a valid month- Comparing Dates
- Best way to do nested case statement logic in SQL Server
- How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
- SQL: Two select statements in one query
- SQL conditional SELECT
- DATEDIFF function in Oracle
- MySQL error: Unknown column in ‘where clause’
- Postgresql column reference “id” is ambiguous
- How to order by column A and then by column B?
- Help me SELECT thumbnail from SQL and use
- how to SELECT meta values that are not null?
- What’s the best way to search for a UPC code in a Database?
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- Case in Select Statement
- Self Join to get employee manager name
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- Online SQL Query Syntax Checker
- Must declare the scalar variable
- Must declare the scalar variable
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- IDENTITY_INSERT is set to OFF – How to turn it ON?
- How to reset AUTO_INCREMENT in MySQL
- Why does NULL = NULL evaluate to false in SQL server
- How do composite indexes work?
- Difference between one-to-many and many-to-one relationship
- MySQL “WITH” clause
- Error Code: 2013. Lost connection to MySQL server during query
- SQL join on multiple columns in same tables
- ORA-00918: column ambiguously defined in SELECT *
- How do I format date and time on ssrs report?
- SQL Switch/Case in ‘where’ clause
- missing FROM-clause entry for table
- How to run a SQL query on an Excel table?
- MySQL Error 1264: out of range value for column
- How to parse XML data in SQL server table
- The backend version is not supported to design database diagrams or tables
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Sql query to insert datetime in SQL Server
- Difference between View and table in sql
- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
- SQL selecting rows by most recent date with two unique columns
- pg_ctl: no database directory specified and environment variable PGDATA unset
- Postgres Error: More than one row returned by a subquery used as an expression
- ERROR 1148: The used command is not allowed with this MySQL version
- Comparing Dates in Oracle SQL
- How to divide two columns?
- MySQL starts with searching issue
- Difference between INNER JOIN and LEFT SEMI JOIN
- SQL “select where not in subquery” returns no results
- ListAGG in SQLSERVER
- The used SELECT statements have a different number of columns
- using sql count in a case statement
- PostgreSQL visual interface similar to phpMyAdmin?
- Oracle: If Table Exists
- Equivalent of explode() to work with strings in MySQL
- How to calculate age (in years) based on Date of Birth and getDate()
- How to create id with AUTO_INCREMENT on Oracle?
- Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot
- How can I group by date time column without taking time into consideration
- What is the difference between Views and Materialized Views in Oracle?
- Append table to an existing one: SQL Server
- SQL Server – An expression of non-boolean type specified in a context where a condition is expected, near ‘RETURN’
- “select * into table” Will it work for inserting data into existing table
- ORA-01735: invalid ALTER TABLE option – Toad
- Update query using Subquery in Sql Server
- “This SqlTransaction has completed; it is no longer usable.”… configuration error?
- Use wpdb->prepare for `order by` column name
- register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
- prepare() not working
- How do I move a WordPress site to another server?
- Return number of items in a table with post id
- Cron While Editing Post
- Debugging WordPress
- Pull data and display as rows and columns
- find pods item where relationship to other pod is not set
- Convert a category of posts to a custom post type using (MySQL) queries
- I need a SQL command to delete specific authors and all posts connected with them
- Connect to Ms SQL Server
- How can i restore only Blogs from a SQL backup file?
- DB_HOST – is LOCALHOST speedy than domain name? [closed]
- wpdb prepare sql problem
- Can Anyone provide an example of RAW SQL for SELECTING posts by 2 or more tags
- REGEXP_REPLACE in post_contet
- How to change post published date to today date with SQL
- Menu Order updating automatically
- Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
- How delete post_content records of specific category from phpmyadmin
- Fastest way to display 5000 post titles?
- Is it possible to utilize custom SQL for a single-post.php?
- How to handle my row actions on a custom list table in the admin section
- blank page after update my theme
- Sql query returns empty. But not
- How can I avoid duplicate primary keys in SQL import?
- SQL – JOIN last child
- Adding profile data to database
- Firebase with WordPress instead of SQL?