Forum Search engin to search keywords in database in php

[neel_1708]

I am developing a intranet forum in Php and MySQL and I am using ajax to display searched results on the same page but right now I am using query LIKE text% to search in database which is slower. but I want to make it fast search engin which can parse *,+ and show result.

 

Since I am using ajax i am not able to use free search engin,so if possible pls provide a complete solution

[Alexv]

Have you tried fulltext indexes?

 

http://dev.mysql.com/doc/refman/5.5/en/fulltext-search.html

[neel_1708]

Thanks for yor reply.

But i also want Wildcard search functionality and for that i want a php code to parse the user input and then form a query eg: user enters bla* then result should contain all occurances of bla.

[Alexv]

Next time take a closer look when someone gives you advice.

 

http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

[Alexv]

Double post. Sorry

[neel_1708]

Thanks Alexv for your reply,I am just starting my carrier as programmer and

i am a newbie to php and mysql.But could have been more generous in your reply instead of being rude.

[QuickOldCar]

Alexv's suggestion is a good one, fulltext in boolean mode is the way to go.

http://dev.mysql.com/doc/refman/5.6/en/fulltext-search.html

requires the MyISAM table type, InnoDB not supported

 

Another alternative is sphinx.

http://sphinxsearch.com/about/sphinx/

 

Or even Lucene

http://lucene.apache.org/java/docs/index.html