So I’m about to start a new project, which will involve a search feature. I’ve made fairly basic searches in PHP / MySQL before using a simple model of something like:
[COLOR=Black]
SELECT * FROM someTable WHERE field1 OR field2 LIKE '%seach_string%';
Obviously this will work, but to a fairly rudimentary level. What I’m looking for is something that can search several fields and return the results ordered to a certain degree of relevancy.
Does anyone know of any good tutorials on creating more advanced search features, or possibly some kind of open source search facility that can be fairly easily tied into a site?
[/COLOR]