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: 153

Filed under:
|
|

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

Related posts about mysql

Related posts about regex