Regexp to mysql

Question

Need to construct regexp to this

2 1231 21231 2312 2123 22 2

Need to find only 2, not 1231, not 21231, only 2

So, my regexp is

^[[:digit:]]?{1}[2]{1}^[[:digit:]]?

Is it right ?

Sorry if my ask like a 'do it for me', but i really cannot into regexp.

UPD
input string 2 22 1312 123123 22312 21 2
need to match "2"
2 22 1312 123123 22312 21 2
with or w\o digits after\before

Could you elaborate a bit more? Is this meant to be one long string or multiple strings to be tested? Try to write it like input: "12 34" and output: "2", possibly using some character to find that's not ambiguous. — Mario
– Mario, Commented Apr 13, 2012 at 11:31
input string 2 22 1312 123123 22312 21 2 need to match "2" 2 22 1312 123123 22312 21 2 with or w\o digits after\before — Abyss
– Abyss, Commented Apr 13, 2012 at 11:34

Madara's Ghost · Accepted Answer · 2012-04-13 11:41:30Z

1

Sounds simple enough...

/\b2\b/g

How about this one? Example

edited Apr 13, 2012 at 11:41

answered Apr 13, 2012 at 11:36

Madara's Ghost

176k52 gold badges274 silver badges314 bronze badges

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

1 Comment

gowri Over a year ago

How could i use this in Mysql query? While selecting a column i hav e to select individual number like this, how could i achieve this? SELECT * FROM table WHERE table_id REGEXP /(/\b2\b/)/g;

Collectives™ on Stack Overflow

Regexp to mysql

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related