why does this not work
Archived 2 years ago
X
xTTLegend
Verified
It works in my SQL Console in DBeaver, but this does not work and sets everything to zero.
i use `modernc.org/sqlite`
```go
func calculateLikes() {
_, err := db.Exec(`UPDATE notes SET Upvotes = (SELECT COUNT(*) FROM reactions WHERE reactions.Tags LIKE '%e","' || notes.ID || '%' AND reactions.Content = '+')`)
if err != nil {
log.Fatal(err)
}
}
```