How access database performs fuzzy query

Microsoft Office Access is a relational database management system released by Microsoft. It combines the two features of MicrosoftJet Database Engine and graphical user interface, and is one of the system programs of Microsoft Office.

(Learning video sharing: Programming video)

MS ACCESS stores data in its own format in a database engine based on Access Jet. It can also directly import or link data stored in other applications and databases.

The difference from SQL is that its fuzzy query uses LIKE “*word*” instead of LIKE “%word%”. In addition, in batch fuzzy queries, there is no need to use the form

LIKE "*word1*" OR LIKE "*word2*" OR LIKE "*word3*"

. You can use square brackets to simplify:

LIKE "*[word1,word2,word3]*"

.

Related recommendations: access database tutorial

The above is the detailed content of How access database performs fuzzy query. For more information, please follow other related articles on the PHP Chinese website!