Searching all fields

[Anon]

ok i've tried

SELECT FROM table WHERE table. LIKE '%whatever%'

How do I search the whole database for a single string???

thanks

ash

[[deleted]]

By telling SQL exactly which tables to search in.

Only do this if you don't care about performance.

If you do care about performance, create a search-engine. Read the article 'slapping together a search engine'