INSERT INTO Status (AssetTag,Status,Comment,EnteredBy) VALUES ('4426','EOL - Pend Scrap','','acaiafa') ;  UPDATE `Asset` SET `Status_Current` = 'EOL - Pend Scrap' WHERE CONVERT( `AssetTag` USING utf8 ) = '4426' LIMIT 1 ;