SELECT MATCH(table1) AGAINST (table2) as Relevance FROM table
as i understood .. match is not available in access/sql. Is it possible to get this function in Access 2003?
i have Levenshtein in a vba function working in access.. but i want to compare it to the match function from mysql
the problem is still the same... MATCH in mysql is part of the sql language, compiled into mysql engine. if you create a vba function, it will be an "outside" function, not being able to use some kind of index (which is the main goal of the full-text index...)
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> i have Levenshtein in a vba function working in access
note that such a function cannot use any index on the tables, so will do result in a full table read ... not really coool...
0
Amien90Author Commented:
thanks for the response
the match function of mysql is available right? (open source). i could rewrite that code to vb.. perhaps anyone did this allready?
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.