For Programmers: Free Programming Magazines  


Home > Archive > PHP SQL > February 2006 > Re: show tables WHERE ?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: show tables WHERE ?
NC

2006-02-28, 6:58 pm

malcolm wrote:
>
> What I really want is a query like 'Show tables where prefix like aa_'


Easy, really:

SHOW TABLES LIKE 'aa_%'

Cheers,
NC

Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com