On 17-Apr-01 Matt \"TrollBoy\" Wiseman wrote:
> How would I word a query to see what tables exist in a db that begin with
> box
>
> for example include
> boxTABLE1
> boxTABLE2
> boxTABLE3
> but exclude
> sphereTABLE1
>
> I'm basically trying lo populate a list box with the tables beginning with
> box in PHP.
>
mysql> show tables;
+-----------------+
| Tables_in_cache |
+-----------------+
| admh020 |
| ctl |
| hs021132 |
| pending |
| signc |
| signd |
| tmpc |
| tmpd |
| trnc |
| trnd |
+-----------------+
10 rows in set (0.02 sec)
mysql> show tables like 'tmp%';
+------------------------+
| Tables_in_cache (tmp%) |
+------------------------+
| tmpc |
| tmpd |
+------------------------+
2 rows in set (0.02 sec)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
