Update MySQL table with counts from subquery if string match, else set to zero up vote 0 down vote ...
stackoverflow.com