List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 21 2002 10:53pm
Subject:RE: Selecting set members
View as plain text  
At 17:18 -0500 2/21/02, John Fulton wrote:
>Neil,
>
>Thank you for giving me that idea.  That exact syntax did not
>work with "=" but using "like" worked well.  Problem solved.

You might find that using FIND_IN_SET('afternoons',availability)
works as well.

>
>Thanks,
>   John
>
>
>mysql> select availability FROM application;
>+-----------------------------------------------------------+
>| availability                                              |
>+-----------------------------------------------------------+
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekends,mornings                                         |
>| weekends,mornings                                         |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>+-----------------------------------------------------------+
>14 rows in set (0.00 sec)
>
>mysql>
>
>
>mysql> select availability from application where availability =
>'%afternoons%';
>Empty set (0.00 sec)
>
>mysql>
>
>
>mysql> select availability from application where availability like
>'%afternoons%';
>+-----------------------------------------------------------+
>| availability                                              |
>+-----------------------------------------------------------+
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>| weekdays,weekends,mornings,afternoons,evenings,overnights |
>+-----------------------------------------------------------+
>12 rows in set (0.00 sec)

Thread
Selecting set membersJohn Fulton21 Feb
RE: Selecting set membersJohn Fulton21 Feb
  • RE: Selecting set membersPaul DuBois21 Feb