Solved

Access 2003: Match Function

Posted on 2008-10-05
5
232 Views
Last Modified: 2013-11-05
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
0
Comment
Question by:Amien90
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22645592
>as i understood .. match is not available in access/sql
correct.

you will have to use some "real" database engine like MySQL, MS SQL Server, Oracle etc which do support full-text indexing.

are you aware that you could use ms access as front-end, and keep the database in MySQL, and with pass-through queries use the MATCH() function?
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 22645599
> 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
 

Author Comment

by:Amien90
ID: 22647627
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
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 22647635
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...)
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question