SQL count how many times a word exists in a text field or memo
Posted on 2004-10-06
I am trying to make a search box on a database driven website with dynamic content.
I would like to be able to search using keywords on a text field.
I would like to rank the search by the number of times that it exists in the field.
So if one row contained the word 2 times, it would be ordered higher than a row that had the keyword only once.
How would I do this?