you could use the FIND_IN_SET(str,strlist) function which returns a value 1
to N if the string str is in the list strlist consisting of N substrings.
Returns 0 if str is not in strlist or if strlist is the empty string.
Returns NULL if either argument is NULL.
If you want to find all the records that have 'North' you query will look
something like this
SELECT * FROM table_name WHERE FIND_IN_SET('North',regions_field)>0
From: Joseph Koenig <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, June 28, 2001 4:50 AM
Subject: [PHP-DB] Modify Query, or sift through results?
>I've got a script that searches a db every night and sends out e-mail if
>it finds something a person would be interested in, based on criteria
>they gave us. The problem is that I have one field that stores regions
>of the country in a very unpleasant way. It stores them as:
>So all of the regions for one record go into one field. The problem is
>that when searching that, if someone has a preference of 'North', I
>dont want to pull records that have 'Northeast', as would happen with
>the above example. Is there a way to modify the MySQL query so as to
>find only 'North', keeping in mind that 'North' may be the 3rd in a list
>of semi-colon separated regions? Or do I need to sift through the
>results in PHP to clean them up? Thanks,
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]