Search using LIKE Clause Mysql

I'm tring to convert a Mysql query to using a LIKE clause and I can't make it work.

$query = "SELECT id,name FROM `hin` WHERE name = '".$q."'";

What I've tried in some variatio开发者_如何学运维ns.

$query = "SELECT id,name FROM `hin` WHERE name LIKE %'".$q."'%";

I need the query to select row only on string match. Intend is to use variable as needle.

---

Use:

"SELECT id,name FROM `hin` WHERE name LIKE '%". $q ."%'"

The wildcarding has to be inside the single quotes.

Ideally, you want to use:

"SELECT id,name FROM `hin` WHERE name LIKE '%". mysql_real_escape_string($q) ."%'"