home / media

media: count_directors

Custom SQL query returning 1 row (hide)

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

Query parameters

This data as json, CSV

total
148
Powered by Datasette · Queries took 0.307ms