Hello.
> 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. Another approach is not to use external scripts, but rather stored routines and INFORMATION_SCHEMA databases in MySQL 5.0. mel list_php wrote: > 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 > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
