"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> 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. If your tables are all identical, which it sounds like, you want to create a Merge Table: see http://dev.mysql.com/doc/mysql/en/merge-storage-engine.html Alec -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]