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
using wildcards?
>
> mysql> select * from application where availability = '%mornings%';
>
> Crude, but it should work.
> Neil
>
>
>
> -Original Message-
> From: John Fulton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 22 February 2002 7:49 AM
&g
If I have a table with a set such as this:
CREATE TABLE application (
application_num int(6) NOT NULL auto_increment,
availability set('weekdays','weekends','mornings','afternoons')
default NULL, PRIMARY KEY (application_num)
) TYPE=MyISAM;
is it possible to search based on members of the s
