paginate
paginate copied to clipboard
add multi-like filter (mlike)
- mlike filter allows to search using like in many fields
- example http://localhost:3000/?filters=["name,summart,title","mlike","john"]
SELECT * FROM user WHERE name LIKE '%john%' OR summary LIKE '%john%' OR title LIKE '%john%' LIMIT 10 OFFSET 0
- you can achieve same behaviour chaining many likes but the filter strings grows too much
very interesting. I think this is a smart proposal.
may i merge yours into like
, not like
, ilike
and not ilike
operators?
this will be the default behavior, but I might add some changes. thanks
PR #18