MySQL Query Question

[devanium]

If I have a database full of names, for example, and I want to query how many "John" names are in the database, how can I do this?

Any help would be greatly appreciated

Thanks!

 

[gamex]

You can do something like this:

$result = mysql_query("SELECT * FROM Table WHERE FirstName = 'John'") 
$num_rows = mysql_num_rows($result);

 

[sjp]

select count(*) from table where name = 'John'

 

[phpmyborder]

or

SELECT * FROM Table WHERE Firstname LIKE '%John%'


then you'll get all names containing John.. like 'Johnny', 'Big John' ... etc...