I want to write a little searching script for my database. I googled that and only found a few related Scripts. Some of them employ the LIKE keyword of the SQL and the other use the full-text search in MYSQL. But both ways have some limitation. The LIKE keyword is not effiecent when searching for more than one keyword. The full-text search function is useless in searching for words less than 4 characters. Is there any solution to do searching better in php and how do the CMSs like phpnuke, oscommerce do the searching of the content?
php searching script