Re: find_in_set syntax

2001-12-12 Thread Wiliam Stephens
At 17:40 11/12/01, you wrote: >Can you provide your table description? > >You have two set colums? One called res_skills and one called >res_skills_ma ? Yeah, Both are SET columns. Wil - Before posting, please check: http:/

Re: find_in_set syntax

2001-12-12 Thread Etienne Marcotte
mysql> create table gd_records( -> id int unsigned auto_increment, -> res_skills set("skills1","skills2","skills3","skills4","skills5","skills6"), -> res_skills_ma set("skills_ma1","skills_ma2","skills_ma3","skills_ma4","skills_ma5","skills_ma6"), -> primary key(id)); Query OK, 0 r

Re: find_in_set syntax

2001-12-11 Thread Etienne Marcotte
Can you provide your table description? You have two set colums? One called res_skills and one called res_skills_ma ? Etienne Wiliam Stephens wrote: > > Hi > > Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well, > I'm using the following: > > ELECT * FROM gd_

Re: Re: find_in_set syntax

2001-12-11 Thread Wiliam Stephens
At 17:23 11/12/01, you wrote: >Your message cannot be posted because it appears to be either spam or >simply off topic to our filter. To bypass the filter you must include >one of the following words in your message: > >database,sql,query,table > >If you just reply to this message, and include the

find_in_set syntax

2001-12-11 Thread Wiliam Stephens
Hi Can anyone tell me what is wrong with the MySQL FIND_IN_SET function? Well, I'm using the following: ELECT * FROM gd_records WHERE res_skills & 3 AND res_skills_ma & 3; And it returns the most weird results. It completely ignores the AND statement, and returns results even if the