LIKE statement

[Anon]

I have created my SELECT statement in my sql query. When a user types in a word, the query should return all rows with that word in it. The problem I am having, is either they must enter every word in the ENTIRE field for this statement:
"SELECT * FROM table WHERE recipe LIKE '$recipe'"

and if I put % around the word recipe ('%$recipe%', it finds everything containing the word in the varibale.

The problem with that, is if they type in "cup", not only does it bring up cup, but it will also bring up "cupcake". I need it to bring up the word they entered and that only.

What do I need to do?

Thanks!

Seth

[soulreaver]

Why don't you give the user the option on the form to either find an exact match or a close match? The all you need is an if statement along the lines of

if(!$exact){
$sql=" SELECT FROM TABLE WHERE recipre LIKE $RECIPE%"
}else{
$sql="=" SELECT FROM TABLE WHERE recipre LIKE $RECIPE"
}

(Ignore my SQL Syntax this was done in a hurry). Then if the user chooses exact match they will get just that otherwise they will get something that is close, their choice.

Neil Williams

[Anon]

Try dropping the like and use =. i.e.

SELECT * FROM table WHERE recipe = '$recipe';"