search through one/several tables

[mel list_php]

Hi list,

I would like to search for something into one or several tables.
My first idea was to retrieve the tables' names, then for each of them 
retrieve the columns' name and have a look in each of this column.
Is there a more elegant (fast) way to do that with mysql?

Somebody has some tips/doc where I could look for search engines?My problem 
is that I don't have one big table with all the data but several little ones 
with few fields, so I don't think solutions like Lucene could work.

Thanks for any help,
Melanie

_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 
http://www.msn.co.uk/messenger