Autocompletion

Custom SQL query returning 5 rows (hide)

SELECT name, gender FROM first_names
WHERE name LIKE :name || "%"
AND gender LIKE IFNULL(NULLIF(:gender, ""), "%")
GROUP BY name, gender
ORDER BY count DESC
LIMIT 5

Query parameters

gender

name

Edit SQL