Consider different 3 cases.
First US at first: Here use 'US,%'
Second US at middle: Here use '%,US,%'
Finally US at last: Here use '%,US'
Thus change your Having clause as
HAVING (TAGS LIKE 'US,%' OR TAGS LIKE '%,US,%' OR TAGS LIKE '%,US')
Hope this will help :)