lundi 24 août 2015

-can NEAR queries be order sensitive?

e.g. there are 2 records

1- "sqlite is a database tool"

2- "database can be built by using sqlite"

when I use

SELECT * FROM docs WHERE docs MATCH 'sqlite NEAR database';

it will return both records

The question is:

how to return only the first record where "database" is after "sqlite"

Thanks.

Aucun commentaire:

Enregistrer un commentaire