RE: searching ALL tables

["Cal Evans" <cal@xxxxxxxxxxxx>]

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