Re: AW: AW: find in list

2006-08-17 Thread Michael Stassen
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

AW: AW: find in list

2006-08-16 Thread Charlie Schaubmair
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

Re: AW: find in list

2006-08-16 Thread Michael Stassen
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

Re: AW: find in list

2006-08-16 Thread Mike van Hoof
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

Re: AW: find in list

2006-08-16 Thread Mike van Hoof
: 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

Re: find in list

2006-08-16 Thread Mike van Hoof
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

find in list

2006-08-16 Thread Charlie Schaubmair
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