Re: Retrieving partial field values

[Stephen Moretti]

Kentucky Families wrote:

>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?
>  
>
You need to do an IN query.

SELECT column,list,here
FROM tblBMD
WHERE Surname IN ('stotts','statts','stutts')

http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html#IDX1235

Regards

Stephen