Posted by Steve on 02/28/06 16:01

> On my rented space I have only one database. I have a few users at my
> site
> and any mysql tables I made for them have their initials as a prefix
> i.e.
> aa_phonelist, aa_addresses, aa_otherjunk
> bb_phonelist, bb_addresses, bb_otherjunk
> I want to make a drop down selection for the tables so that each can see
> his/her tables
> but ONLY theirs. What I really want is a query like 'Show tables where
> prefix like aa_'
> and send the results to the drop down. Obviously that won't work

<cough!>

SHOW TABLES LIKE "aa_%";

---
Steve

[Back to original message]