List tables that have specific string

This site is best viewed in a modern browser with JavaScript enabled.

lilfellabob

Hi all,

I am wanted to list tables from my database, but only tables that contain a certain string.
Say I have a database with four tables:
honda_car
yamaha_bike
kawasaki_bike
ford_car
I want to be able to list all tables that contain 'car'.

Any help is greatly appreciated

Josh

lilfellabob

After more searching, I found what I am looking for. In case anyone else find this when trying to do the same thing:

$sql = "SHOW TABLES FROM demonsi1_db LIKE '&#37;_gallery'";
$do_sql = mysql_query($sql);
while($row = mysql_fetch_array($do_sql))
{
	echo $row['0'] . "<br>";
}

ssystems

In asking for help on databases I always advise to indicate what database you are using.
In MS SQL you have

USE <DATABASE>
SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = '<SCHEMA>' AND TABLE_NAME LIKE '&#37;<STRING>%'