What is the equivalent of REGEXP_SUBSTR in mysql?
- by KandadaBoggu
I want to extract a word from a string column of a table.
description
===========================
abc order_id: 2 xxxx yyy aa
mmm order_id: 3 nn kk yw
Expected result set
order_id
===========================
2
3
Table will at most have 100 rows, text length is ~256 char and column always has one order_id present. So performance is not an issue.
In Oracle, I can use REGEXP_SUBSTR for this problem. How would I solve this in MySQL?