Retrieving partial field values

[Kentucky Families]

Very new to MySQL and this list. Thanks in advance for your patience with elementary
questions. I'm in process of converting a current web site to a mysql database. As this
database will eventually contain millions of records, I want to set it up properly.
 
The database will contain transcriptions of birth, marriage and death records. For surname
fields, I would like for my transcribers to be able to enter multiple values for records
that are difficult to read. For instance, a surname that could be read Stotts or Statts
or Stutts. If I use a VARCHAR or TINYEXT field to enter these values and I want to be
able to retrieve all records where the surname field contains the whole word Stotts, how
would I enter these values:
 
stotts or statts or stutts
stotts,statts,stutts
other?
 
Thanks,
 
--Sheryl

		
---------------------------------
Do you Yahoo!?
 Read only the mail you want - Yahoo! Mail SpamGuard.