CODEWITHSUNDEEP
mysql
Sakthi Vel L
Sakthi Vel L

Reputation: 43

How to extract string between two special characters in mysql

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

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

How to write MySQL script to get 101 out of <101>?

Upvotes: 3

Views: 12599

Answers (1)

Ullas
Ullas

Reputation: 11556

Use SUBSTRING_INDEX to achieve this.

Query

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

Fiddle demo

Upvotes: 5

Related Questions