mysql statement with 3 or's

[carlfaulkner]

Basically i want something like this SELECT * FROM table WHERE confirmed="1" and column1 like '%value%' or column2 like '%value' or column3 like '%value%' WHERE ....... I have a search bar and when clicking enter i want to search all rows where confirmed = 1 and any of the 3 other table columns are like the search string entered. Any ideas, but the above doesnt work. It does if i use just 2 or's

[justsomeguy]

Use parentheses to separate the OR and AND conditions.

[carlfaulkner]

I managed to get it working using WHERE Confirmed = '1' and CONCAT(title, description, city) like '%$searchstring%'