[thelist] MySQL search everywhere?

Stephen Rider evolt_org at striderweb.com
Tue Oct 6 07:46:31 CDT 2009


Hi --

Hopefully this is dead simple for you DB folks out there....

Can anyone give me a quick MySQL command to search everywhere for a  
particular string?

SELECT * FROM * WHERE ??? = "foo"

I don't know what to put at the "???".  I want to search all tables,  
all fields, for the string.

Thanks,
Stephen

-- 
Stephen Rider
http://striderweb.com/

P.S. -- Sorry if you get two copies of this.  Sent from wrong account  
before....



More information about the thelist mailing list