tags:

views:

137

answers:

5

What does the slash character mean in this query? This is being used with a MySql database.

SELECT Channel, COUNT(Channel) AS Total, COUNT(Channel) / (SELECT COUNT(*) FROM UserClicks WHERE (Date > '2009-12-1' AND Date < '2010-1-1') AND RoleType='member' ) AS Percent FROM UserClicks WHERE (Date > '2009-12-1' AND Date < '2010-1-1') AND RoleType='member' GROUP BY Channel ORDER BY Total DESC

Update: sorry, stupid question! =P

+9  A: 

It's a division sign. It's dividing two numbers.

Langdon
OMG I think I won!!
Langdon
+2  A: 

It is the division operator.

Ian P
+1  A: 

It literally means "divided by".

DanM
+2  A: 

It is the division operator. See the manual:

http://dev.mysql.com/doc/refman/5.0/en/arithmetic-functions.html#operator_divide

RedFilter
+1  A: 

It's the division operator

Jason