MySql Not Like Regexp?
Posted
by KnockKnockWhosThere
on Stack Overflow
See other posts from Stack Overflow
or by KnockKnockWhosThere
Published on 2010-04-05T16:22:52Z
Indexed on
2010/04/05
16:23 UTC
Read the original article
Hit count: 152
I'm trying to find rows where the first character is not a digit. I have this:
SELECT DISTINCT(action) FROM actions
WHERE qkey = 140 AND action NOT REGEXP '^[:digit:]$';
But, I'm not sure how to make sure it checks just the first character...
© Stack Overflow or respective owner