Similar Products with bitwise
Yes, just use bitwise &amp; operator:

select products.genres, genre.Id from 
products inner join genre 
on products.genres &amp; genre.Id &gt; 0 
order by products.genres, genre.Id


SQL Fiddle