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.
