[RESOLVED] Problem with NOT LIKE

fotofx

I have a field that gets concatenated with additional data each time the record is used. This field is called included_campaigns.

Running the following query:

SELECT * 
FROM
`raw_leads`
WHERE
`raw_leads`.`entry_date` >=  '2010-01-01 00:00:00' AND
`raw_leads`.`included_campaigns` NOT LIKE  '9122'

It is still returning rows that contain "9120-4616-9120-9122-" and "4616-9120-9122-"

I even tried using the % after the 9122 in the query..

I am stumped.. Any thoughts?

dagon

NOT LIKE '%9122%'

fotofx

Thanks.. Don't know how I missed that.. Tried everything else..

dagon

how about reading the manual first (String Comparison Functions), that's always a good idea.

fotofx

Actually I did read the manual first (And a few mysql bibles). The percent sign is shown as a wildcard and that is how I was trying to use it. Because in many cases the characters I am looking for are the first four in the string, I only tried using it at the end. I didn't think to use it at both sides.

Thanks again for all your help.

dagon

not trying to belabour the point, but:

"9120-4616-9120-9122-" and "4616-9120-9122-"

neither of the strings has 9122 as the first four, both have other characters to both sides, hence the need for % on both sides.

fotofx

Yup, I realize that now but in many of the records it is the first four and was still coming up in the return. I probably should have included a few other sample strings. That is what I like about this board. Sometimes when you stare at something long enough, the obvious gets missed. Always nice to have fresh eyes..