I have a music site that I need to get a search engine for that works well and is relevant.
The table structure is like this:
Artist
- artistid
- artist
Song
- songid
- artistid
- title
I need a search where somebody can search "artist - song name" and they'll get some results sorted by relevance.
MySQL Full Text will not work on this because it doesn't span accross multiple tables, so please don't suggest it.
Furthermore, whatever you do DO NOT try to tell me or give me work that does "where artist.title like '%$search%' or song.title like '%$search%'" (or even break it down into works and then do it. I absolutly do NOT want a single query script that will crash my server by searching through mass titles.
NOTE: When pitching me your bid, please include what method you plan to use and how you think you're right for the job. I'm willing to pay good money, for a good script but I need somebody who's capable and will create something that will work for me.