Pre vyčítanie a porovnanie čísla v tabuľke s hodnotami je možne použiť regexp a substring_index

drop table if exists t;
create table t (col varchar(100));
insert into t values ('Description Number 9 MOre description');
insert into t values ('Description Number 549 MOre description');
insert into t values ('Description Number 549 MOre description');
insert into t values ('Description Number asd MOre description');


select 
    case 
        when col regexp '.*Number [0-9]+.*' 
        then substring_index(substring_index(col, 'Number ', -1), ' ', 1)
    end 
from t;

Vystúp funkcie:

Live kód:

https://rextester.com/EJX96105

   Send article as PDF