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
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
