search

multiprocessio / datastation

App to easily query, script, and visualize data from every database, file, and API.
https://datastation.multiprocess.io
Other
2.9k stars 112 forks source link

language SQL / no such function: REGEXP #182

Closed aheissenberger closed 2 years ago

aheissenberger commented 2 years ago

There is no support for

SELECT * FROM DM_getPanel(0) WHERE  url REGEXP '\b3\b'
eatonphil commented 2 years ago

Thanks! I'll have to look into this. The SQL panels use SQLite under the hood. Maybe I'm not loading the right extension.

In the meantime you can use LIKE if you'd like or you can do your filtering in JavaScript/Python before using the SQL panel.

eatonphil commented 2 years ago

This fix has been merged and will be part of the next release.