mysql phpmyadmin query quick code job

Job ID: 35045476

Budget: £10 – £25 GBP

Hi

I want a sql query that gets data from table_add

then gets colum add_1
then explodes data by |
GB|RM|B|28140005|ENG|12
and returns
28140005
and updates the sql colum

Only apply for job if it can be sent with a few mins no google search bs coders