FULLTEXT MATCH()
am 08.01.2007 17:11:21 von MossyI am refining the search within a small IT Jobs Website developed in
C#. I am using FULLTEXT search on 3 columns (title, short_desc,
long_desc), but am having trouble becuase some queries for the database
will be "c#" and "asp.net". The Match() function does not recognise
these types of keywords because the length is less that 4 characters
and a "." in words splits it into 2 words each 3 charaters long.
Anyone find a way around this? I like the Match() function as it brings
more relevant result back first in most cases.
Regards,
Tomas