count separed with comma values in a column in MySQL

    SELECT
           film.film_id,
           film_actor.actor_id,
           actor_award.awards,
           LENGTH(actor_award.awards) - LENGTH(REPLACE(actor_award.awards, ',', '')) +  1 as total_award
        FROM film
        JOIN film_actor ON
        film.film_id = film_actor.film_id
        LEFT JOIN actor_award ON actor_award.actor_id = film_actor.actor_id