need to match strings that are close

[mystrymaster]

I would need to be able to match a search string here

my query is

mysql_query = ("SELECT ID, Name, Num FROM garage where Name Like '$shopName%'");


I have tried

%$shopName%
%$shopName

but I can't get this string to match

R W Lakeview

with

R.W. Lakeview

I need to be able to match on slight inconsistencies if that is possible.

Any Help?

[ir4z0r]

try that:

mysql_query = ("SELECT ID, Name, Num FROM garage WHERE Name LIKE '%" . $shopName . "%'");