Monday, April 28, 2008

mysql query show tables with like and where

Thease querys will solve those problem.

show tables like "%countries%"
show tables where Tables_in_databasename="countries"

just change the second query <databasename> with u r original database name.

i hope helps u....


No comments:

Post a Comment