I am not sure, but I think mySQL just as MS SQL, has a free text index. Check the mySQL manual for further information. -----Original Message----- From: Herhuth, Ron To: php-windows@lists.php.net Sent: 2003-12-10 19:05 Subject: DB Indexing Quick question...does MySQL offer column based indexing? I'm looking to store resume text which can be quite lengthy in a database field for searching. I have already built the app that takes a MS Word resume and extracts and stores keywords in MS SQL and the searches are lightning fast with over 500 resumes, but a new client of mine isn't running MS SQL so I have to look at the reality of trying to use MySQL as a solution. Thanks, ROn -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
