Charlie Schaubmair wrote:
Hello Michael,
thx, I know normalisation.
BUT normalisation isn't always the best (fastest) way to store, or select
the datas, this is why I don't use it most time.
Often I'm testing my projects with normalisation and without and my last
very big problem with big selec
ubmair
> Betreff: Re: AW: find in list
>
> Charlie Schaubmair wrote:
> > Hello,
> >
> > I want to do a query where I only gt the results by a
> numeric value:
> >
> > select * from MyTable where 1 IN someFieldInMyTable > I
> know this quer
Charlie Schaubmair wrote:
> Hello,
>
> I want to do a query where I only gt the results by a numeric value:
>
> select * from MyTable where 1 IN someFieldInMyTable
> I know this query doesn't work, but maybe anyone knows what I mean.
>
> 1 can be a value betwenn 1 and 23
> someFieldInMyTable is n
alue the where clause is done...
Maybe it helps
Mike
Charlie Schaubmair schreef:
Hello Mike,
thx, but isn't there another way?
br
Charlie
-Ursprüngliche Nachricht-
Von: Mike van Hoof [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16.
August 2006 10:46
An: Charlie Schaubmair
C
: Mike van Hoof [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 16. August 2006 10:46
An: Charlie Schaubmair
Cc: mysql@lists.mysql.com
Betreff: Re: find in list
Charlie Schaubmair schreef:
Hello,
I want to do a query where I only gt the results by an
numeric value:
select * from MyTa
Charlie Schaubmair schreef:
Hello,
I want to do a query where I only gt the results by an numeric value:
select * from MyTable where 1 IN someFieldInMyTable
I know this query doesn't work, but maybe anyone knows what I mean.
1 can be a value betwenn 1 and 23
someFieldInMyTable is normaly
Hello,
I want to do a query where I only gt the results by an numeric value:
select * from MyTable where 1 IN someFieldInMyTable
I know this query doesn't work, but maybe anyone knows what I mean.
1 can be a value betwenn 1 and 23
someFieldInMyTable is normaly a list like: 1,2,3,4,5,6,9,21