How to search a mysql db

[Goldwyn <goldwyn_r@xxxxxxxxxxxx>]

Dear Friends,

How does a person search a Mysql database using a query. I am not talking of 
a simple select clause which can check for equality only. 

I am trying to search a search string which could be a sub-string of a 
record's field value.

eg  my database contains 2 fields(only) - full name and full address.
I want to search the database by first name or by city which is just a part 
of the fields full name and full address.

I am sorry if this is Off-Topic.

Thanx for the help in advance
-- 


Goldwyn :o)