How To: Create multiple like statements based on passed vector

[madhat2r]

Does anyone know how this can be accomplished?

(get-lists ["free" "food"]) ->

Select name 
From Lists
Where name like '%free%' and name like '%food%'

I have tried:

-- :name get-lists :? :*
Select id, name
from Lists
where
--~ (clojure.string/join "" (interpose " AND " (map #(str "name LIKE '%" % "%'") :sKeyWords)))

But of course that does not work. Can someone point me in the right direction please?

[madhat2r]

Figured out answer. Putting here for anyone else who might need it.

-- :name get-lists :? :*
Select id, name
from Lists
--~ (str "WHERE " 
        (clojure.string/join "" 
        (interpose " AND " (map #(str "name LIKE '%" % "%'") (:key-words params)))))