SELECT multiple tables WHERE field = x?

[RIRedinPA]

If I have a db with a bunch of user generated tables and I want the user to be able to select a list of the available tables how would I write that query?

 

For example - every table would have these fields, id, username, password, projectname, projectdate and my list of tables would be:

 

foo_projectname1

foo_projectname2

otherfoo_projectname1

thisfoo_projectname1

thisfoo_projectname2

thisfoo_projectname3

 

I want to pass a query something to select all of foo's tables and use the password field, a query kind of like -

 

SELECT ALL TABLES WHERE TABLENAME LIKE 'FOO%' WHERE password = 'xxxxxx'

 

Is that doable?

[rhodesa]

http://us3.php.net/manual/en/function.mysql-list-tables.php