subject:"Question about IN operator"

Question about IN operator

2003-02-15 Thread Don! Briggs

I have a field (cdfeature) that contains a list of comma seperated values. Example follows: select item_id, cdfeature from cars where (101 in (cdfeature)); +-+-+ | item_id | cdfeature | +-+-+ | 320 | 101,104,106 | |

Re: Question about IN operator

2003-02-15 Thread Paul DuBois

At 12:41 -0600 2/15/03, Don! Briggs wrote: I have a field (cdfeature) that contains a list of comma seperated values. Example follows: select item_id, cdfeature from cars where (101 in (cdfeature)); +-+-+ | item_id | cdfeature |