MySQL Forums
Forum List  »  Newbie

get numbers only question
Posted by: Jassm Rahma
Date: July 20, 2014 02:16AM

I tried this:

SELECT employee_number FROM employees WHERE employee_number REGEXP ('[0-9]');

it's working excellent and I getting these numbers

7, 8, 9, 11, 1.222, 12, 13, 9, 15, 9, 9, 9

BUT....

when I run:

SELECT MAX(employee_number) FROM employees WHERE employee_number REGEXP ('[0-9]');

I get 9 where i should get 15.

why is that?

Options: ReplyQuote


Subject
Written By
Posted
get numbers only question
July 20, 2014 02:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.