RE: [PHP] select question
| From: | Don Read | Date: | Wed, 18 Apr 2001 00:06:46 +0000 |
| Subject: | RE: [PHP] select question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49091@lists.php.net to get a copy of this message | ||
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 dread@texas.net
-- 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.