Re: searching ALL tables

["Adam Crawford" <ca@xxxxxxxxxxxxxxxxxxxx>]

no, they do not have the same structure,
someone said something about creating a loop using php

since idealy this will end up being a web published database
this sounds good to me, just i have no idea how i would do that

*claims being new to sql & php*
I've scanned thru both of the manuals (mysql & php)
havent seen anything about this yet, think its time for a closer look.

Any other help welcome,
Thank you,
Adam Crawford

----- Original Message ----- 
From: "Cal Evans" <cal@xxxxxxxxxxxx>
To: "Adam Crawford" <ca@xxxxxxxxxxxxxxxxxxxx>; <mysql@xxxxxxxxxxxxxxx>
Sent: Friday, March 09, 2001 10:52 PM
Subject: RE: searching ALL tables


You can't.  SQL wasn't designed to do that.

Do all your tables have the same structure?

Cal
http://www.calevans.com
 

-----Original Message-----
From: Adam Crawford [mailto:ca@xxxxxxxxxxxxxxxxxxxx]
Sent: Friday, March 09, 2001 1:53 AM
To: mysql@xxxxxxxxxxxxxxx
Subject: searching ALL tables


Hi all,
I just want to know how to search all tables
I can work out how to search one table, or a few of them at a time
but since we have 1000+ tables, I figure there must be an easyer way
I have tried using % & * instead of the table name, but with no luck

Hope someone can help
Thank you in advance.

Regards,
Adam Crawford

ps, please be sure to cc me a copy of any replys, as i am not subscribed to
the list.


---------------------------------------------------------------------
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 <mysql-thread67756@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-cal=calevans.com@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php



---------------------------------------------------------------------
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 <mysql-thread67768@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php