select *, char_length(replaced) from( select *, lower(left(trim(country),9)) as replaced from cc_csv as cc )t1 lower upper left right substring trim upper < left < trim < replace REPLACE(REPLACE(region,'&','and'),'.','') AS character_swap_and_remove REPLACE(TRIM(event),'-','') AS event_fixed, select *, trim(replace(replace(distance, 'km',''),'null','0')) as distancefixed ,left(replace(duration,'null','0'),2) as durationfixed ,replace(pickup_time,'null','') as pickuptimefixed ,coalesce(replace(cancellation,'null',''),'') as cancellationfixed from runner_orders as ro