mysql - Updating multiple rows in one column in a database -

i have database data

i want edit column lab_no , add 0 (0) after 8 records... how can because records many. thank you

assuming records begin epi8, can this:

update [tablename] set lab_no = replace(lab_no, 'epi8', 'epi80');