Use this::
SELECT * FROM MyTable WHERE (Column1 LIKE '%keyword1%' OR Column2 LIKE
'%keyword1%') AND (Column1 LIKE '%keyword2%' OR Column2 LIKE '%keyword2%');
More Related Contents:
- How can I search (case-insensitive) in a column using LIKE wildcard?
- How to speed up SELECT .. LIKE queries in MySQL on multiple columns?
- MySQL Like multiple values
- Search for string within text column in MySQL
- MySQL join query using like?
- Which is faster — INSTR or LIKE?
- MySQL – How to search for exact word match using LIKE?
- Like Case Sensitive in MySQL
- MySQL SELECT LIKE or REGEXP to match multiple words in one record
- Mysql: Order by like?
- mysql like performance boost
- how to use a like with a join in sql?
- How do you force mysql LIKE to be case sensitive? [duplicate]
- mysql_fetch_array() expects parameter 1 to be resource, boolean given in [closed]
- How to group by two rows in a column
- How to perform grouped ranking in MySQL
- How to abort INSERT operation in MySql trigger?
- Mysql or/and precedence?
- ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
- Migrate from Oracle to MySQL
- Which is more efficient: Multiple MySQL tables or one large table?
- How to skip columns in CSV file when importing into MySQL table using LOAD DATA INFILE?
- MySQL InnoDB foreign key between different databases
- Replace Into Query Syntax
- adding RMySQL package to R fails (on Windows)?
- Ruby gem mysql2 install failing [duplicate]
- MySQL “IN” queries terribly slow with subquery but fast with explicit values
- How to create and insert a JSON object using MySQL queries?
- Update multiple rows with multiple ‘where’ clauses for each individual row
- WHERE datetime older than some time (eg. 15 minutes)