WHERE Concat(table1.columna, ' ', table2.columnb) like '%foo%' AND Concat(table1.columna, ' ', table2.columnb) like '%bar%' view plaincopy to clipboardprint? WHERE (table1.columna LIKE '%foo%' OR table2.columnb LIKE '%foo%') AND (table1.columna LIKE '%bar%' OR table2.columnb LIKE '%bar%') WHERE (table1.columna LIKE '%foo%' OR table2.columnb LIKE '%foo%') AND (table1.columna LIKE '%bar%' OR table2.columnb LIKE '%bar%') view plaincopy to clipboardprint? WHERE (table1.columna LIKE '%foo%' AND (table1.columna LIKE '%bar%' OR table2.columnb LIKE '%bar%') ) OR (table2.columnb LIKE '%foo%' AND (table2.columnb LIKE '%bar%' OR table1.columna LIKE '%bar%') )