searching all tables

[misfits]

hi all,
i have about four tables in my db and i want to be able to search all the tables,
i was thinking something like this::
SELECT from where $string
but as i expected i get a syntax error

not only that but i would also like to use a string to search,
so does php and sql (the db is odbc) have a fuzzy search function ??
any suggestions would be much appreciated
thanks
Ape-De

[Thatsmej]

not only that but i would also like to use a string to search,

can help you with this..

select * from table where field like '%search query%'

[Danicek]

You can try SQL, just study syntax little bit more.

Something like:

Select *
from table_name
where collumn_name like '%$string%'

should work for one table. Do it 4 time for 4 tables or join results with union.