search in part of record

In thsi code:

$Sql = "select * from $TableName where MEMBER='*word*'";
$Result = mysql_query($Sql);
while ($Row = mysql_fetch_array($Result))
{

I want to search for word but in any part of record so I use (*) to mean any letters before or after word but it does not work .

How can I serach for ward in any part of record ???

Thanks.......

don't use * but use %

$Sql = "select * from $TableName where MEMBER='%word%'";
$Result = mysql_query($Sql);
while ($Row = mysql_fetch_array($Result))
{

Thank you toooooooooooooooooooooooooooooo much