Calculate same values [Problem]

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
sweb
Forum Newbie
Posts: 18
Joined: Tue Oct 30, 2007 6:32 am
Location: Iran (Semnan)

Calculate same values [Problem]

Post by sweb »

i need the MySQL query for calculate the number the rows that have a same value in a one or more cells:
See my example:

Code: Select all

 
-----------------------------------------
# | user_ip | user_useragent | user_lang
-----------------------------------------
1 | 55.12.15 | Firefox        | en
2 | 55.12.11 | Firefox        | en
3 | 55.12.15 | IE             | en
4 | 55.12.15 | Opera          | en
5 | 55.12.15 | Firefox        | de
6 | 55.12.15 | IE             | en
7 | 55.12.81 | Firefox        | en
-----------------------------------------
 
Request : That calculate number of rows that have a same value in the `user_lang` and `user_useragent`:
The rows 1, 2, 7 have same value in `user_lang` and `user_useragent`. >> 3 row
Also the rows 3 and 6 have same value in `user_lang` and `user_useragent`. >> 2 row
The result must be 5.
Did you understand? I want the SQL comment to process for getting number 5.

I can use the array_unique in PHP for calculate but i want process it with MySQL functions.
thanks and be waiting.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Calculate same values [Problem]

Post by jaoudestudios »

This should point you in the right direction...

Code: Select all

SELECT count(id) as total, user_useragent FROM *table_name* GROUP BY user_useragent
Post Reply