el list_php <[EMAIL PROTECTED]>, mysql@lists.mysql.com
Subject: Re: search through one/several tables
Date: Wed, 23 Mar 2005 10:46:10 -0600
Shawn, Mel
>I am not aware of any SQL dialect that supports a query of the kind you
>are asking about. If there were such a query it _might_ look some
AS cnt FROM tbl_name WHERE cnt > 0 GROUP BY id;
>
> http://dev.mysql.com/doc/mysql/en/problems-with-alias.html
>
>
>
> >From: Peter Brawley <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
> >To: [EMAIL PROTECTED]
> >CC: mel list_php <[EMAI
x27;%Smith%' or fullName like '%Smith%' or adress like '%Smith%'.
But maybe this is not a good way to do things?
Melanie
From: [EMAIL PROTECTED]
To: "mel list_php" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: search throu
in all the columns, a shortener for select * from dbLab where name
like'%Smith%' or fullName like '%Smith%' or adress like '%Smith%'.
But maybe this is not a good way to do things?
Melanie
From: [EMAIL PROTECTED]
To: "mel list_php"
of Dallas, L.P.
(469) 384-6009
> -Original Message-
> From: mel list_php [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 23, 2005 10:09 AM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: search through one/several tables
>
> I can find the dat
r fullName like '%Smith%' or adress like '%Smith%'.....
>
> But maybe this is not a good way to do things?
>
> Melanie
>
>
> >From: [EMAIL PROTECTED]
> >To: "mel list_php" <[EMAIL PROTECTED]>
> >CC: [EMAIL PROTECTED],mysql@l
rom: [EMAIL PROTECTED]
To: "mel list_php" <[EMAIL PROTECTED]>
CC: [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: Re: search through one/several tables
Date: Wed, 23 Mar 2005 09:55:23 -0500
"mel list_php" <[EMAIL PROTECTED]> wrote on 03/23/2005 06:00:08 AM:
> Unfo
AIL PROTECTED]
> >CC: mysql@lists.mysql.com
> >Subject: Re: search through one/several tables
> >Date: Wed, 23 Mar 2005 10:44:53 +
> >
> >"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> >
> > > Hi list,
> > >
exceed
> 500-1000/table. But I may sometimes have to search into dna sequences
> (around 5000 atcg characters in any order), so that is quite heavy.
Maybe
> for that field a fulltext index would be helpful?
>
> Thanks for your help,
> Melanie
>
>
> >From: [EMA
at is quite heavy. Maybe
for that field a fulltext index would be helpful?
Thanks for your help,
Melanie
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: search through one/several tables
Date: Wed, 23 Mar 2005 10:44:53 +
"mel list_php" <[EMAIL
"mel list_php" <[EMAIL PROTECTED]> wrote on 23/03/2005 10:14:07:
> Hi list,
>
> I would like to search for something into one or several tables.
> My first idea was to retrieve the tables' names, then for each of them
> retrieve the columns' name and have a look in each of this column.
> Is ther
Hi list,
I would like to search for something into one or several tables.
My first idea was to retrieve the tables' names, then for each of them
retrieve the columns' name and have a look in each of this column.
Is there a more elegant (fast) way to do that with mysql?
Somebody has some tips/doc
12 matches
Mail list logo
