Get data from strings with format using Mysql

Question

I want to get the data numbers from the string in this format using Mysql:

A-10001(b)

Which means the output should be something like:

I would like to know whether there is a way which is better than using SUBSTRING. Thanks.

Maybe this link can help you... you should add a MySQL function for that. Let me know if it helps you!!! — Alvaro Niño
– Alvaro Niño, Commented Feb 12, 2018 at 12:13
This probably won't help with your current problem but with mysql version 8.0 you'll be able to use REGEXP_SUBSTR dev.mysql.com/doc/refman/8.0/en/… — Paul Campbell
– Paul Campbell, Commented Feb 12, 2018 at 12:43
You are welcome, remember to vote up if it helps you @AlvinLau — Alvaro Niño
– Alvaro Niño, Commented Feb 13, 2018 at 11:07

O. Jones · Accepted Answer · 2018-02-12 12:23:04Z

1

Is there a way which is better than using SUBSTRING [to pull 10001 from A-10001(b) ?

No. Not in a MySQL query. Whatever you do will almost certainly end up involving SUBSTRING().

A wise programmer might choose to do this in a host language, like php or Java.

answered Feb 12, 2018 at 12:23

O. Jones

110k17 gold badges134 silver badges187 bronze badges

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

1 Answer 1