mysql count question

[billgod]

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

[fenway]

first write a query to find the matches, then worry about counting them....