select *
from 
   mytable
where 
   myspalte like '%HHH%' and
   length(replace(replace(myspalte,'L'),'E')) = 3