Re: matching an option from SET list

2001-12-13 Thread Carl Troein
Wiliam Stephens writes: My two columns are set up as follows: res_places SET('North','West','South') res_places_re SET('Aber','Cardiff','Bangor') And I'm currently using the following MySQL query: SELECT * FROM gd_records WHERE (res_places 3)

matching an option from SET list

2001-12-12 Thread Wiliam Stephens
Hello I've got a problem selecting values that match an option from a SET column. My two columns are set up as follows: res_places SET('North','West','South') res_places_re SET('Aber','Cardiff','Bangor') And I'm currently using the following MySQL query:

Re: matching an option from SET list

2001-12-12 Thread Benjamin Pflugmann
Hi. On Wed, Dec 12, 2001 at 02:39:07PM +, [EMAIL PROTECTED] wrote: Hello I've got a problem selecting values that match an option from a SET column. My two columns are set up as follows: res_places SET('North','West','South') res_places_re