Hi Gleb,all,
Thanks for the reply, but unfortunatly we are still under 4.0 and I have
absolutely no control on that.(and I tried!!)
So basically except the external script no option?
Anything for the wildchars? :-(
> 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_* ?
Thanks,
melanie
From: Gleb Paharenko <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: Re: global search
Date: Wed, 14 Dec 2005 12:48:22 +0200
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]
_________________________________________________________________
Are you using the latest version of MSN Messenger? Download MSN Messenger
7.5 today! http://messenger.msn.co.uk
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
