table names from database

[Anon]

hello,

how can we show the list of all table names in a particular page through a .php page and can we use the where clause in that sql statement. something like ---

select table_names from database_name where table_name like '%xyz%'

thanks in advance

vishwa vivek

[[deleted]]

Depends on which database-type you are using, mysql, postgres, informix, snoreacle.

[Anon]

i am using MySQL 3.23

please help

thanks

vishwa vivek

[[deleted]]

in MySQL: you can run queries like
SHOW DATABASES;
SHOW TABLES;
DESCRIBE table_name;

Run these queries from the commandline and see what you get.
You can also run these queries from PHP to get the info there.

http://www.mysql.com/doc/S/H/SHOW.html

[Anon]

thanks a lot Dear Mr. Vincent

the SHOW command is working from the php page also.

thanks

vishwa vivek