[RESOLVED] Extending my search engine

[Azala]

Hey!

Need some help extending my search engine.

I currently use PHP to search my mySQL tables. The current code is something like this:

SELECT * FROM blabla WHERE blabla RLIKE %blabla% OR blabla RLIKE %blabla%

Which works fine, except that in order to get a hit on for instance COOKIE, you have to type in COOKIE.

I want to make it so that if I type in COO, CO, COOk, COOkI or c I will get a hit on COOKIE because the word COOKIE has the searchphrase as part of its letters.

Any ideas?

[redink]

You can use MySQL Regexp. Check it here..

http://dev.mysql.com/doc/mysql/en/regexp.html

[Azala]

Thanks, exactly what I needed.