MySql functions update

Hi all, I was looking for a way to COUNT results from a query and make them unique , i.e counted once, like DISTINCT clause

Try Occurrence (String)