Use it like this, assuming your name field
SELECT name, COUNT(id) as number_of_searches FROM profiledb WHERE name="dog"
4
solved How to select the number of names equal to value and save the number of searches found into a variable [closed]
Use it like this, assuming your name field
SELECT name, COUNT(id) as number_of_searches FROM profiledb WHERE name="dog"
4
solved How to select the number of names equal to value and save the number of searches found into a variable [closed]