SELECT WHERE field DOES NOT CONTAIN a string??? HOW?
Posted: Thu Dec 19, 2002 1:50 pm
I want to select only records where a field DOES NOT contain a string in it...
So for instance, the contents of the fields might be:
Record 1: 1, bla bla bla i rock http://www bla bla bla
Record 2: 2, wowzers that rocks bla balj
Record 3: 3, this rocks mysql is great http://www.blue
Now, I want to select all records where that field DOES NOT have http:// in it. So it should JUST SELECT RECORD 2.
Whats the syntax for that?
So for instance, the contents of the fields might be:
Record 1: 1, bla bla bla i rock http://www bla bla bla
Record 2: 2, wowzers that rocks bla balj
Record 3: 3, this rocks mysql is great http://www.blue
Now, I want to select all records where that field DOES NOT have http:// in it. So it should JUST SELECT RECORD 2.
Whats the syntax for that?