How do I design a priority based mysql search?

Just displaying the result won't help.

[AjiNIMC]

Hi,

In the world of Google just querying the DB and showing the result on the basis of Article ID is not sufficient. It should be arranged in a prioritized way.

If I search for "blue widget”, it should return me most relevant result from the DB not just the articles containing the word "blue widget".

Is there an open source application for it? I will appreciate developing on the open source rather starting it from scratch.

Thanks
AjiNIMC

[ergophobe]

You can get that from the MySQL Fulltext indexing and searching. It will give a score of how well it thinks the search matches and you can order by that score.

I've used it some and it works nicely, but with some quirks.

[AjiNIMC]

I am trying to implement one of these

* Nutch - lucene.apache.org/nutch/
* Xapian - www.xapian.org

Difficult job ahead :)

[chirp]

Build pages from your database, install ht://Dig and be done with it ;)

[AjiNIMC]

But my problem is I am using a third party server for main site. Till beta it is ok as I have complete access. With normal ssh access how feasible is it to implement such complex systems.