Results 1 to 2 of 2
Thread: MYSQL Query ????
May 26, 2002, 20:09 #1
- Join Date
- Aug 2001
- 0 Post(s)
- 0 Thread(s)
MYSQL Query ????
I want to do something similar to this
from (select table_name table from user_tables)
where (desc table) like '_%'
but I know I cant run the (desc table) part - I want to do something like that.
I want to have all the fields in the where clause and I dont want to have to type them all out (if possible)
I do realise that this query will take a long long time to actually execute and I do know that the subquery will only search for tables available to the user that is logged in