SELECT `ORDER_NO` AS `OD_NO`, `SLIP_COMMENT` AS ` COMMENT`, (length(replace(`SLIP_COMMENT` , ',', ',,')) - length(`SLIP_COMMENT`) + 1) AS `CNT` FROM `ORDERS` ORDER BY `CNT` DESC, `OD_NO` DESC;