Search using LIKE Clause Mysql

[null]

I'm tring to convert a Mysql query to using a LIKE clause and I can't make it work.\[code\]$query = "SELECT id,name FROM `hin` WHERE name = '".$q."'";\[/code\]What I've tried in some variations.\[code\]$query = "SELECT id,name FROM `hin` WHERE name LIKE %'".$q."'%";\[/code\]I need the query to select row only on string match. Intend is to use variable as needle.