SELECT CONCAT(‘CNA’, LPAD(@rownum:=@rownum+1,5,0)), ticket_no FROM ipm_ticket, (SELECT @rownum:=0) r;
UPDATE ipm_ticket c INNER JOIN
(SELECT CONCAT(‘CNA’, LPAD(@rownum:=@rownum+1,5,0)) AS cna_no, ticket_no FROM ipm_ticket, (SELECT @rownum:=0) r
) d
ON c.ticket_no=d.ticket_no
SET c.cna_no=d.cna_no;