> but still not present, like REGEXP/RLIKE and BETWEEN
Since 1.24.11 Photon supports MySQL style REGEXP/RLIKE and ILIKE, as well
as classic LIKE. BETWEEN and NOT BETWEEN are also now supported.
To address questions about /i modifier for RegExps: both in Mango and in
the Photon version of SQL one should start a regex with (?i) to make it
case insensitive. So RLIKE '(?i)^a' (or {$regex:'(?i)^a'} in Mango) matches
both 'a' and 'A'.
https://github.com/ermouth/couch-photon
ermouth
On Tue, Apr 4, 2023 at 12:44 AM ermouth <[email protected]> wrote:
> Hi,
>
> happy to announce Photon 1.24.2, a new version of an alternative CouchDB
> admin panel.
>
> Photon now incorporates glynnbird/sqltomango which allows querying CouchDB
> using a subset of SQL syntax. The feature is available in the dropdown
> where all DB view indices and feeds live.
>
> https://github.com/ermouth/couch-photon
>
> Enjoy!
>
> Cheers,
> ermouth
>
