CODEWITHSUNDEEP
clojureclojureql
yazz.com
yazz.com

Reputation: 58796

In ClojureQL how can I make a where clause case insensitive?

In ClojureQL how can I make a where clause case insensitive? I am trying to add UPPER or something to do this in the where clause but I can't figure out how to do this

Upvotes: 3

Views: 177

Answers (1)

Daan
Daan

Reputation: 10314

In ClojureQL you can call a function like this:

:function/col

So something like this should work according to the documentation:

(select (table :users) (where (= :LOWER/name john)))

Upvotes: 2

Related Questions