I was practicing this question [Weather Observation Station 11] When I used
select distinct city
from station
where regexp_like(city, '^[^aeiou]|[^aeiou]$');
gave me the correct answer (458 results) where
select distinct city
from station
where not regexp_like(city, '^[aeiou]|[aeiou]$');
gave me the wrong answer (299 results).
I felt both '^[^aeiou]'
and NOT '^[aeiou]'
should gave me the not starting with aeiou results, but apprently not. What's the logical differences between these two answers?