[thelist] A SQL request on a SET() field type

[Damien Cola]

Hello,
the = operator doesn't work for checking if a field has the value:

Select * from mytable where mysetfield = 'UK';
works if mysetfield is ('UK')
doesn't work if mysetfield is for example: ('UK', 'FR')

I have tried replacing = with LIKE with no success.

What is the secret of the SET type ?

I've looked up the documentation (online and books) but with no mention of
my particular case.

Thank you.

Damien COLA - Synaptique
Synaptique (UK) Ltd.
Eurogate Business Park
TN24 8XW, Ashford, Kent
Tel: +44 (0)870 777 0026
Fax: +44 (0)870 777 0027
http://www.synaptique.co.uk
Offices: Ashford, Brussels, Helsinki
Milan, Montreal, Paris, Rabat, Toulouse