[mikeshn]

If I'm login to MySQL and want to find certain table, but I have no idea where the table is located (in what database).

How can I search for a table in mysql ?

Thanks

[qha_vn]

you wanna search for a table programatically or manually?

[GerryKing]

Originally posted by mikeshn
If I'm login to MySQL and want to find certain table, but I have no idea where the table is located (in what database).

How can I search for a table in mysql ?

Thanks

Brute force way -- show databases;
Then for each database returned --
use "one of the returned database";
show tables;

[omiossec]

You can try

show tables like 'your table name'