search

dbcli / litecli

CLI for SQLite Databases with auto-completion and syntax highlighting
https://litecli.com
BSD 3-Clause "New" or "Revised" License
2.06k stars 67 forks source link

REGEXP #134

Closed hardikajmani1 closed 2 years ago

hardikajmani1 commented 2 years ago

Hey, How to use REGEXP for SQLite? It was released officially.

Additionally how to check which version of SQLite is used for the cli?

zzl0 commented 2 years ago

Thanks for your feedback, it is using the SQLite of your Python environment. You can check the SQLite version in your Python shell.

zzl0 commented 2 years ago

We have the REGEXP keyword here https://github.com/dbcli/litecli/blob/c8cc767927d37bbeb5f33d18754871238a7fba35/litecli/sqlcompleter.py#L142

zzl0 commented 2 years ago

@hardikajmani1 updated the link.