UPDATE customer SET name = 'asdas123123', contact = 'qwe123', phone = '', other_phone = '213', fax = 'qweasd', inv_terms = '0', credit_limit = '21312.00', bill_to_address = 'aaaasdadwwqsa', bill_to_apt = 'ssqdqqqq', bill_to_city = 'qweew', bill_to_state = 'IA', bill_to_zip = 'q', ship_to_address = 'aaaasdadwwq', ship_to_apt = 'ssqdqqqq', ship_to_city = 'qwe', ship_to_state = 'IA', ship_to_zip = 'q', check_shipping_address = '', description = 'sewq', credit_hold = '', active = 'true' WHERE id = '269'###insert into entity_audit (entity, entity_id, code, action, changes, user_id) 
                        values ('customer',269, '','UPDATE', '{\"userId\":\"61\",\"input\":[{\"elemId\":\"customer_form_name\",\"from\":\"asdas123123\",\"to\":\"asdas123\"}],\"mt\":[]}', 61)###UPDATE `customer`
    SET avatarLetter = UPPER(CONCAT(
        CASE 
            WHEN LEFT(name, 1) REGEXP '[A-Za-z]' THEN LEFT(name, 1) 
            ELSE ''
        END,
        CASE
            WHEN LOCATE(' ', name) > 0 THEN 
                CASE
                    WHEN SUBSTRING(name, LOCATE(' ', name) + 1, 1) REGEXP '[A-Za-z]' THEN SUBSTRING(name, LOCATE(' ', name) + 1, 1)
                    ELSE
                        CASE 
                            WHEN LENGTH(name) > 1 AND SUBSTRING(name, 2, 1) REGEXP '[A-Za-z]' THEN SUBSTRING(name, 2, 1)
                            ELSE ''
                        END
                END
            ELSE
                CASE 
                    WHEN LENGTH(name) > 1 AND SUBSTRING(name, 2, 1) REGEXP '[A-Za-z]' THEN SUBSTRING(name, 2, 1)
                    ELSE ''
                END
        END
    ))
    
    WHERE id = 269 AND deleted = '0';