List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 6 2000 2:46pm
Subject:Re: SELECTing from a SET()
View as plain text  
>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
Thread
SELECTing from a SET()Margie Wiers6 Apr
  • Re: SELECTing from a SET()Paul DuBois6 Apr
  • Re: SELECTing from a SET()Margie Wiers6 Apr
    • Re: SELECTing from a SET()Paul DuBois6 Apr
  • Re: SELECTing from a SET()Margie Wiers6 Apr