MySQL searches

[admin]

I would like to know how you can search for partial and full words. For instance i have a field called first name in my mySQL database. If i search for Jarret i would like to show Jarrit and Jarred as search results. I was doing a where clause where fname = frist_name. Is thier something that will search part of it also.

Thanks.

Ira