Thanks for your reply. I am using MySQL and the options for fulltext are very limited. The techniques you describe sound more advanced than what I’m used. Are they more for enterprise level?
I suppose, still using a blog as an example, you would want to place more weight on occurrences in the title. Is this possible with MySQL fulltext?
What do you class as small amounts of data? I typically work with tables under 10k records. I only really do sites for SMEs.