Pascale Lunal wrote: > Dear Joseph, > > Thank you for your quick reply. The MERGE function may do the trick but > then I would have to type the name of the 50 tables ! The idea was to > avoid having to type evey single table. Also, what will happen if new > tables are created ? I'll have to re-merge them all ? > > P.L.
You have to type your 50 table names only once, when you create your MERGE table (It is a *table* not a function). If you want to add new tables, you run ALTER TABLE. Looking at the manual should help ;) : http://www.mysql.com/doc/en/MERGE.html Just wondering: Why don't you use a single table, since they all have the same structure ? Regards > >> From: Joseph Bueno <[EMAIL PROTECTED]> >> To: Pascale Lunal <[EMAIL PROTECTED]> >> CC: [EMAIL PROTECTED] >> Subject: Re: PHP search query into all tables of a MySQL db >> Date: Thu, 26 Sep 2002 12:04:53 +0200 >> >> Pascale Lunal wrote: >> >>> Oops: sorry if this message appears twice but my connection broke >>> down just when I clicked 'send'. >>> >>> Hello, >>> >>> I am currently writing a search query in PHP to: >>> >>> 1. search in MySQL database (not in one table but in all the tables >>> of the whole database), >>> >>> 2. search when more than one searchterm is entered (it works for 1 >>> search term but not for more). >>> >>> My questions related to the above two points are: >>> >>> 1. How do I modify the following line (basically how to change >>> "mytable" to "allmytable") so that all the tables are searched (each >>> table has exactly the same structure) wihtout having to type every >>> single table name (since I have 50 of them !) ? >>> >>> $query = "SELECT * FROM mytable WHERE columnname LIKE '%$searchterm%'"; >>> >> Since all your tables have the same structure, you can create a "merge >> table" and run your select on it. >> >>> 2. The search is performed by typing the word to be searched. This >>> works for 1 word but not if I enter more than 1 term. How can I make >>> a multiple word search ? >> >> >> You should split your $searchterm in multiple words and build a query >> that looks like: >> SELECT * FROM mytable WHERE columnname LIKE '%$word1%' AND columnname >> LIKE '%$word2%'... >> (Sorry for not beeing more specific but it is a PHP, not MySQL, problem >> and I have no experience in PHP). >> >>> >>> Any help, example scripts, tutorials would be greatly appreciated. >>> >>> Best regards, >>> >>> Pascale >>> >> Regards >> -- >> Joseph Bueno --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php