SQLselect : RegEx search records where field DOES NOT contain string

[Richard Altenburg]

On 26-03-2003 16:52, "Ruslan Zasukhin" <sunshine at public.kherson.ua> wrote:

>> Ruslan Zasukhin wrote:
>>> Question is: query
>>>   SELECT * FROM myTable WHERE myStrField NOT LIKE 'BCD' no_case
>>> do not work for you correctly???
>>> Or you have not try?
>> Yes I tried, but it does not work...
> 
> Send me small db 
> 
> I will try in viSQL.

I think the original poster should try this:


    SELECT * FROM myTable WHERE NOT myStrField LIKE 'BCD' NO_CASE


So the word NOT should be right after WHERE, and shouldn't be before the
word LIKE.

Try it, you might be surprised!