How To Separate Mysqli Query After Coma : I am bit confused at one situation. I have a table called slam-book in which I have a column named favorite games. Now User enters their data like

    "cricket, foot ball, hockey, basket ball" 

Now I want to separate this result and want to give link to it like,

    <a href="/game.php=cricket">Cricket</a>, <a href="/game.php=foot-ball">Foot Ball</a>, <a href="/game.php=hockey">Hockey</a>, <a href="/basket-ball.php=hockey">Basket Ball</a>

So, I can list all users with specific interest, Please help me to get such result. I want that code which can give me results like #2 code.