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 ?
|
|
|
|
> 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
| |
| malcolm 2006-02-28, 6:58 pm |
| indeed <cough> !
I spent hours trying to make a 'WHERE'
good grief !
thank you
On Tue, 28 Feb 2006 09:01:23 -0500, Steve <google.spam@nastysoft.com>
wrote:
>
>
> <cough!>
>
> SHOW TABLES LIKE "aa_%";
>
> ---
> Steve
>
|
|
|
|
|