search full word or any word

[Anon]

Hi..
Can anybody tell me how to search a database that the result will come out either by full keyword or partially.
Let say i want to search for Catherine Zeta Jones
1.Full Keyword : Chatherine Zeta Jones
2.Partially Keyword : Zeta

Both keyword will return the same result.

Thanks

[Anon]

Use LIKE opeator in query to search for particular keyword in database field

[Anon]

I know this need LIKE operator but how the query look like?
Anabody??

[tijger]

Hi Anie/Annie,

Did you try it? Or do you want other people think for you?

Read the MySQL Manual:
http://www.mysql.com/doc/S/t/String_comparison_functions.html

And use AND and OR. It is really easy, believe me. You only have to use your brains.
So have fun!

greetings

[gio2k]

And you only have to learn to be polite. But that's not really easy...
Just keep your comments to yourself, and help if you want to help.

-Gio-