SHOW tables from.

Limiting results

[henry0]

I cannot figure/remember what would be the syntax and if I could do something like that:

I need to show a listing of existing tables on MySQL database
but I need to SHOW only tables that start with the prefix: " dir_ "

thanks
regard

Henry

[henry0]

Thanks case closed!

I had it but put 'dir_%' before "from" instead of at the end

so the correct one is:
"SHOW tables from YOUR_DB like 'dir_%'";

[coopster]

Right on, sir. I'm surprised you didn't just hit the books [dev.mysql.com] for that one ;-)

[henry0]

Go figure :)
This results from an hidden side of my brain
The PHP manual reflex works "A" OK
Cannot groove the MySQL one!

I hate to be politically correct
But anyways at least I do offer a choice
Merry Christmas
Or Happy Holidays