Multiple search and find in sql

Question

I'm new to SQL and I'm stuck on a multiple find in SQL.

Here I'm trying to search table1 in the three columns. But I'm stuch in trying to find two phrases. I'm trying with an OR statement.

If I remove OR LIKE '%paris%' it works but how do I find multiple words/phrases. And would this statement be case sensitive?

I'm also using MySQL to run the above.

SELECT * FROM `table1`
WHERE
CONCAT_WS('|',`target_1`,`target_2`,`target_3`) 
LIKE '%london%' OR LIKE '%paris%'

Answer 1

In your code your second condition is sintactically wrong because is missing the a part for the match

so you should repeat the condition as

SELECT * 
FROM `table1`
WHERE CONCAT_WS('|',`target_1`,`target_2`,`target_3`) LIKE '%london%' 
OR CONCAT_WS('|',`target_1`,`target_2`,`target_3`) LIKE '%paris%'