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) >

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 SET('Aber

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: SELE