SQL search wildcard

ceanth

hi all im using this:

$result = mysql_query("select *

from product
where product_name like '$catsearch%'
order by product_name");

to search for a wild card, in my table the product name is made up of two names, e.g wall paper

now if i search for paper it wont be displayed in my results table, what is the wildcard code that will get php to look at all the names in the database field?

mystrymaster

%paper%

ceanth

if i do '%catsearch%' it wont know what the value is

mystrymaster

what do you mean you won't know that the value is?

ceanth

$catsearch refers to the textbox labeled catsearch hence why i used $catserach to refer to it on the next page. if u replace this with %catseach% it doesnt know what the value is cause there is no $ if u see where im coming from😕

mystrymaster

so do

'%$catsearch%'

I don't understand the problem

ceanth

umm ok ill try in the evening, let u know if it works later, cheers for your help 🙂