Is it possible to do a "show tables" similar to a select statement
where ...


similar to: select field where anotherfield like "ABC%" gives matches
for all "field" which begins with ABC

I'd like to say 

show tables like "ABC%"


ie.  to get a list of all tables whose name begins with ABC.

Thanks in advance.


// sql query


---------------------------------------------------------------------
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

Reply via email to