Select query with regular expression - MySql

Question

I want to select records if a particular column has numbers in its name.

Table 1

ID   EmpCode    EmpName
1    1C         Name1
2    2C         Name2
3    C3         Name3
4    CD         Name4
5    CD         Name4
6    C6D        Name6
7    7CD        Name7

I need to select records 1,2,3,6,7 based on EmpCode. How can this be performed?

EDIT: EmpCode can have number in any position

You mean, you want to select all rows where EmpCode starts with a digit? Please be a little more specific. — fredley
– fredley, Commented Sep 21, 2010 at 10:31

RolandoMySQLDBA · Accepted Answer · 2013-03-20 04:34:26Z

4

SELECT * FROM table WHERE EmpCode REGEXP '[0-9]'

Or alternatively, if you want to check for 'starts with a digit' instead of 'contains a digit':

SELECT * FROM table WHERE EmpCode REGEXP '^[0-9]'

Edit: REGEXP (not REGEX) is the correct function name...

edited Mar 20, 2013 at 4:34

RolandoMySQLDBA

44.4k16 gold badges96 silver badges136 bronze badges

answered Sep 21, 2010 at 10:34

tdammers

20.7k1 gold badge41 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select query with regular expression - MySql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related