Yes you have to break this up into fields that hold your Firstname, MI,Lastname. This has so many advantages, using PHP string function to query inside fields might be useful somewhere else, I wouldn't recommend it for use in a large DB. Divide and conquer! Espero este consejo te sirva, ese error es muy comun, mucha gente quiere guardar nombres completos porque simplifican asi la forma que el usuario llena, bad practice I would say. Christian. =========== "Manuel Ochoa" <manuel@xxxxxxxxxxxxx> wrote in message news:20031106173141.1134.qmail@xxxxxxxxxxxxxxxxxxxxxxxxxx > > I currently manage a MySQL database with about 30000 records. I've given my users the ability to search the name field by pattern. > > For example, the name field can hold 36 characters and contains first name, middle initial and last name. example: > > NAME > John D Miller Jr. > Harry B Davis > Angela De La Cruz > > Users can search for "Miller" or "B Davis" or "a De La" > > Our company is getting ready to purchase a database with 20 million records. I've been told that this type of reach will take too long and that I need to parse out the name field into First name, MI, Last name and suffix. Then allow users to search by first name or last name or both. > > Is this true? Do I need to parse out the name into different fields? Is there any way to do a pattern search and do it efficiently inside of 1 name field? > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
