My Last post was incorrect - sorry. My correct sql statement would be
rlike "(^|;)Midwest(;|$)".
Someone mentioned using Distinct before, which wouldn't work because
Distinct acts on a field, to my understanding, so "Northwest;East" would
be different than "Northwest;South" so it wouldn't really
Ah ha..now it looks like we're on to something. I had to modify it a
bit, but it worked...for the most part. I had to make it rlike
"North[;|$]". But here's the next problem...I have a region 'Midwest'
and 'Upper Midwest'. When I do this search for Midwest, I get the 'Upper
Midwest' results also.
On Wed, Jun 27, 2001 at 08:54:04AM -0500, Joseph Koenig wrote:
> 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 countr
te: 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 fi
Couldn't you use"SELECT DISTINCT" for this?
http://www.mysql.com/doc/S/E/SELECT.html
- Original Message -
From: "Joseph Koenig" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 8:54 AM
Subject: [PHP-DB]
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:
Northeast;West;South
S
