How to extract a string between two special characters in mysql

Question

I am using a query to retrieve the number between special characters from the database.

select number from database where number between like '<%' and '%>'"

How do I write a MySQL script to get 101

from <101>

?

+1

Sakthi Vel L 11 Mar 15 at 5:16 am

1 answer

Wanderer · Accepted Answer · 2015-03-11T05:27:53+0000

Use SUBSTRING_INDEX

to achieve this.

Query

SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(num,'>',1),'<',-1) AS extracted
FROM table_name;