[thelist] SQL (or ASP?) selecting from a multi-valued column

Luther, Ron Ron.Luther at COMPAQ.com
Mon Feb 5 16:34:37 CST 2001


Hi Elfur,


ummm .... What kind of strange things do you get back when you try

Select * from table where field_we_care_about = 1;

or 

Select * from table where field_we_care_about = "1";


I'm guessing you tried these first and they didn't give you what you wanted.

Ron L.

-----Original Message-----
From: Elfur Logadottir [mailto:elfur at elfur.is]

say the column holds the values, "1,3,6,9,10,11,12" but I
want all the records that have "1" (one, not 1 as part of
10)
how do I do that?

I tried "select * from display where cat contains 1 order by
name" but that returns "1,10,11,12".





More information about the thelist mailing list