JRough wrote:
>
> I do know how to do a SELECT query and ORDER BY.
If you know about ORDER BY, why were you complaining about the order of
returned rows and asking "how can I order the tables in order of each of the
3 databases?"

> I did put in the database name in the WHERE clause and that is when I
> got the empty set.
In that case you did not put the database name in in the correct format.

> When I leave out the WHERE clause I get all of the database tables in
> the information_schema.
So do a DISTINCT query on only the table_schema column and see what the
database is ACTUALLY called.

> The problem seems to be in PHPAdmin. There is a drop down list of all
> the databases and the information_schema.
> When I select information_schema in PHPAdmin it ignores the WHERE
> clause.
You are supposed to be running an SQL query in an SQL query box, not listing
the results by using a drop down.