Question: how to search some words at specified field about nano-sql HOT 6 CLOSED

It looks like you've already got a good solution set up.

I am working on an ElasticSearch style feature but it's still being tested, in the meantime what you have is a good solution.

Best,
Scott

from nano-sql.

"LIKE" does not seem to work

from nano-sql.

Don't know why I didn't notice this before, but you're using AND, that's your problem.

Unless the nickname AND username match the query you'll get nothing back. Try using OR.

I've also just pushed an update (v1.5.1) that can help with this kind of stuff. Two new things that can help out:

1. LIKE now uses MySQL wildcard syntax. You can read about it here. A quick example:

nSQL("users").query("select").where(["username", "LIKE", "%richard%"]).exec().then...

2. You can also use Levenshtein distance to find words spelled close to "richard". Like this:

nSQL("users").query("select").where(["levenshtein(richard, username)", ">", 3]).exec().then...

Levenshtein distance calculates the number of changes needed to match a string. For example the levenshtein distance between "you" and "your" is 1 since you only need to add a single letter for one to match the other.

The Levenshtein feature isn't in the documentation yet but it will be soon.

nanoSQL has also supported regular expressions for a while now, so you could do something like this:

nSQL("users").query("select").where(["username", "REGEX", /richard/g]).exec().then...

from nano-sql.

I use redis.

from nano-sql.

That doesn't matter, the features are identical regardless of the database adapter you're using.

Meaning the MySQL style LIKE syntax will work with Redis, IndexedDB, Localstorage or any other adapter that works with nanoSQL.

from nano-sql.

Marking this resolved, feel free to repon it if you run into this issue again.

from nano-sql.