mysql - use of regular expression in query

Question

I would like to create a mysql query that would exclude rows starting by digits using regexp. For instance here I have 1 column "indicators" with the following values:

5-Year Treasury Gilt Auction
52-Week Bill Auction
6-Month Bill Auction
ADP Nonfarm Employment Change
All Car Sales

I would like to create a query such as :

SELECT * FROM table WHERE indicators = [does not start with a digit...];

What is the right way to express such query in mysql?

Gordon Linoff · Accepted Answer · 2016-12-19 02:26:50Z

3

You can just do:

select t.*
from t
where t.indicators regexp '^[^0-9].*$'

Or, you don't need regular expressions at all:

where left(t.indicators, 1) not between '0' and '9'

answered Dec 19, 2016 at 2:26

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

4 Comments

jim jarnac Over a year ago

sorry i am quite noob: why t.* ? why not just *

monikapatelIT Over a year ago

@GordonLinoff nice one +1 from me

monikapatelIT Over a year ago

@jimbasquiat both are same you can use * to select all columns. but if you join multiple tables then better to use tableName.tablecolumnName to avoid ambiguous column error.

monikapatelIT Over a year ago

get more idea here stackoverflow.com/questions/16884705/…

Collectives™ on Stack Overflow

mysql - use of regular expression in query

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related