Hi,
I was wondering if there is any way to do a global search through all the
tables in mysql? (not taking into account the performance issue)
If for example I want to search "ABC" in all the columns of one table:
select * from table where [whatever the column] like '%ABC%'
or globally
select * from [whatever the table] where [whatever the column] like '%ABC%'
I think that if something like that is possible it should also send back the
name of the table.
Last: I prefixed my tables by the step of the project they refer to, for ex
step1_table,step1_table2, step2_table....
Is it possible to use wildchars for the search, something like select * from
step1_* ?
It's probably possible to do a small script describing all the columns then
building a query to search in, but I was wondering if there was an already
existing mechanism.
Thanks,
melanie
_________________________________________________________________
Be the first to hear what's new at MSN - sign up to our free newsletters!
http://www.msn.co.uk/newsletters
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
