mysql split string by comma and count

mysql split string by comma and count

SELECT (LENGTH(`table`.`fieldname`) - LENGTH( REPLACE( `table`.`fieldname` , ',', '' ) ) + 1) AS `number` FROM `table` WHERE TRIM( IFNULL( `table`.`fieldname` , '' ) ) > ''

 

Leave a Reply

Your email address will not be published. Required fields are marked *