tauri-apps / tauri-apps/plugins-workspace
Question: How to create a select statement with null values as parameters
Open
plugin: sql
type: question
- Dominant language
- Rust
- Stars
- 1.8k
- Forks
- 602
- Avg merge
- 4d 14h
- Merged PRs (30d)
- 9
Description
Hi there,
I've got a question regarding select statements from javascript with an sqlite database, where I can have null values as parameter.
```
await database.select('SELECT * FROM table WHERE something = $1', [null]);
```
This is not working. How can this be done?
In Sqlite the operator should be `IS NULL`
Thank you
Contributor guide
Assessment
This issue has not been assessed yet.