Search Posts

Get data from strings with format using Mysql

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:

10001

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

Source: Stackoverflow

Leave a Reply

Your email address will not be published. Required fields are marked *