billgod Posted February 15, 2009 Share Posted February 15, 2009 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 More sharing options...
fenway Posted February 16, 2009 Share Posted February 16, 2009 first write a query to find the matches, then worry about counting them.... Link to comment https://forums.phpfreaks.com/topic/145341-mysql-count-question/#findComment-763210 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.