home / media

media: count_categories

Custom SQL query returning 1 row (hide)

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

Query parameters

This data as json, CSV

total
215
Powered by Datasette · Queries took 0.348ms