[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