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)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
