Re: select question
| From: | Joe Stump | Date: | Wed, 18 Apr 2001 01:46:09 +0000 |
| Subject: | Re: select question | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-49106@lists.php.net to get a copy of this message | ||
In MySQL you can do this:
$sql = "SHOW TABLES LIKE 'box%'";
$r = mysql_query($sql);
// then loop through the tables and populate
--Joe
On Tue, Apr 17, 2001 at 07:49:11PM -0400, 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.
>
> Matt "Trollboy" Wiseman
> www.shoggoth.net/trollboy/trollboy.jpg
> Trollboy@shoggoth.net
> "I wish the world had one throat!!"
> -Al Bundy
>
> ---------------------------------------------------------
> Please do not resell my e-mail address
> to anyone or send me unsolicited e-mail
> ---------------------------------------------------------
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
/* Joe Stump
* Sr. PHP Developer
* http://www.Care2.com http://www.joestump.net http://gtk.php-coder.net
*/