[Resolved] Search for text in a name

[sdm]

I'm currently using this to look for a business name but it only returns the specific one if the whole thins is typed in, what do i need to do to find say 'Tadley Web Design' if someone just types in 'Web Design' ?

This is my current line:

$result = mysql_query ("SELECT * FROM callevapark_businesses WHERE business_name LIKE '$search%'");

I can't remember what the other syntax is.

Thanks,

SDM

[cgraz]

% is a wildcard. That means it represents anything. For example, if you want everything that starts with the letter 'a', you'd use

WHERE field_name LIKE 'a%'

If you wanted everything that ENDS in the letter 'a', you'd use

WHERE field_name LIKE '%a'

So for your problem, I guess you could do

WHERE business_name LIKE '%$search%'

Cgraz