Jump to content

mysql count question


billgod

Recommended Posts

I am trying to do a count of 2 columns in a table.  I need to know the total of how many times a name appears in col1 and col2.  I had it working with 1 column like this

 

select count(*) as namecount, name from mytable  where open='no' group by name order by namecount DESC limit 2

 

now i have a column of name and name2.  I need to know a total of how many times a name is found in name and name2

 

Thanks

 

Bill

Link to comment
https://forums.phpfreaks.com/topic/145341-mysql-count-question/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.