media: count_actresses

Custom SQL query returning 1 row (hide)

SELECT count(*) AS total FROM actresses a
WHERE :q = '' OR lower(a.name) LIKE '%' || lower(:q) || '%'
   OR lower(coalesce(a.nameJa, '')) LIKE '%' || lower(:q) || '%'
   OR lower(a.alias) LIKE '%' || lower(:q) || '%'

Query parameters

q