return table name

[vmicchia]

Is there a way to return what table the results came from if you are searching the whole database?

 

my php search would be like this:

$query = "select * from * where * like \"%$trimmed%\" ";

 

Thank you for any help

 

[Maq]

Is there a way to return what table the results came from if you are searching the whole database?

I'm almost positive that it's invalid to use the '*' wildcard to select every table name.

[vmicchia]

I looked it up and it seemed ok. Perhaps you are right though I will look into it more. Still wondering about the return table name part thought

 

[PFMaBiSmAd]

Without listing each table name using a UNION query, there's no way to search through all the tables in a database, so the answer to your question is no, there's no built in way to do this and since you should not be storing same purpose data in separate tables, you should not be wanting to do this anyway.

[vmicchia]

They are product tables for different types of products.

[fenway]

I looked it up and it seemed ok. Perhaps you are right though I will look into it more. Still wondering about the return table name part thought

 

Then you looked up something else.