Fork me on GitHub
#sql
<
2020-10-30
>
firstclassfunc15:10:15

Morning all, does anyone know how to search for a blank space in a honeySql expression {:update :device :set0 {:qualified false} :where [:like :name '% %']} does not seem to work

seancorfield16:10:28

That should be a Clojure string @gary001: [:like :name "% %"]

seancorfield16:10:51

With single quotes it will quote the first % as (quote %) producing a literal symbol, but the second one -- %' -- is a valid Clojure symbol so it will try to look up %' (and fail).

seancorfield16:10:37

(by the way, when asking for help, "does not seem to work" is not very helpful/specific -- providing the actual error message or describing the unwanted behavior makes it easier for others to help you)