[thelist] MySQL search everywhere?

r937 rudy at r937.com
Tue Oct 6 13:26:05 CDT 2009

> SELECT * FROM * WHERE ??? = "foo"
> I don't know what to put at the "???".  
> I want to search all tables, all fields, for the string.

sorry stephen, it's not good news

SELECT * FROM table1
WHERE column1 LIKE '%foo%'
   OR column2 LIKE '%foo%
   OR column3 LIKE '%foo%
   OR column4 LIKE '%foo%
   OR column5 ...

SELECT * FROM table2
WHERE column6 LIKE '%foo%'
   OR column7 LIKE '%foo%
   OR column8 LIKE '%foo%
   OR column9 LIKE '%foo%
   OR column10 ...


More information about the thelist mailing list