Re: SELECTing from a SET()

[Paul DuBois]

>Thanks, Paul!
>
>Great!  The correct records were retrieved.  Now is there a way to have the
>resultset print only Item1 in each record.  It retrieved Item1 correctly,
>but printed *all* the items.
>
>mysql> select lastname, myitems from mytable
>     -> WHERE FIND_IN_SET("Item1",myitems)!=0;



mysql> select lastname, "Item1" from mytable
     -> WHERE FIND_IN_SET("Item1",myitems)!=0;

-- 
Paul DuBois, paul@stripped