Hi,
I need to find the names of all the tables that have a value in a field.
For example, There are 5 tables: t1, t2, t3, t4, t5
and each one has 6 fieldsm, one of them is f4.
I need the name of all the tables that has "Felix" as a value in the f4 field.

How do I do that?

I basicly need something that will work like this incorrect piece of code:


SELECT * FROM users.* /* users is the database, * meand all tables */ WHERE `name`="Felix"

PHP MySQL.

Thank you.