home / media

media: count_labels

Custom SQL query returning 1 row (hide)

SELECT count(*) AS total FROM labels l
WHERE :q = '' OR lower(l.name) LIKE '%' || lower(:q) || '%'

Query parameters

This data as json, CSV

total
161
Powered by Datasette · Queries took 0.374ms