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
11 matches
Mail list logo
