MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.30


CREATE TABLE test
(
  measure VARCHAR (250) NOT NULL
);
INSERT INTO test VALUES
('75cl'),
('70im'),
('7im'),
('30cim'),
('30clim');
SELECT * FROM test;


measure


75cl

70im

7im

30cim

30clim


--
-- MySQL code
--

SELECT
  measure AS m,
  REVERSE(measure) AS rev_m,
  REGEXP_SUBSTR(REVERSE(measure), 'lc[0-9]+$|[0-9]+$') AS reg_rev,
  REVERSE(REGEXP_SUBSTR(REVERSE(measure), 'lc[0-9]+$|[0-9]+$')) AS m
FROM
  test;


m
rev_m
reg_rev
m


75cl
lc57
lc57
75cl

70im
mi07
07
70

7im
mi7
7
7

30cim
mic03
03
30

30clim
milc03
lc03
30cl


--
-- PostgreSQL code
--

SELECT 
  measure,
  REVERSE(measure),
  SUBSTRING(REVERSE(measure) FROM 'lc[0-9]+$|[0-9]+$') AS first_pass,
  REVERSE(SUBSTRING(REVERSE(measure) FROM 'lc[0-9]+$|[0-9]+$')) AS match
FROM
  test;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'match
FROM
  test' at line 9

`m`	`rev_m`	`reg_rev`	`m`
`75cl`	`lc57`	`lc57`	`75cl`
`70im`	`mi07`	`07`	`70`
`7im`	`mi7`	`7`	`7`
`30cim`	`mic03`	`03`	`30`
`30clim`	`milc03`	`lc03`	`30cl`