Hello, I need a solution to search my MYSQL database in PHP. One table contains around 2.5 million records, each having their own page, by PHP. However, I would like to add a search functionality for these pages. The table in question has several fields, such as name, description, address and more. What I've Tried sphider - won't scale to this size normal mysql LIKE query - takes arouns 23 seconds to query fulltext search - not to sure on this mechanism, read their manual but still confused on it thanks!