Re: Re: Best Approach for Multiple Options
| From: | Marek Kilimajer | Date: | Wed, 03 Sep 2003 12:56:15 +0000 |
| Subject: | Re: Re: Best Approach for Multiple Options | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-161549@lists.php.net to get a copy of this message | ||
Use SET column type if you want. But there is a limit for how many members can the SET type have (64 in MySQL).
I would go with the first approach.
Kae Verens wrote:
this will return true for something like 'pool|fireplace|fitness' mysql_query('select id from theTable where amenities like "%pool%"') you could make it more efficient by using boolean logic: if 1=pool,2=fireplace,4=fitness, then 3=fireplace+pool, 5=fitness+pool, 7=fitness+fireplace+pool just thoughts. Kae