You should really use an existing search engine for that, they contain all the logic you need. There are various other search engines out there that I haven't mentioned, I'm sure you'll find one that works for you.
in reply to Re^2: Database Search Format Engine
in thread Database Search Format Engine
I will be working with the Asian languages, and therefore KinoSearch is out
I know nothing about indexing Asian languages, so out of idle curiosity I wonder what's the issue that KinoSearch has with them (and mysql doesn't). Is there a simple explanation for that?