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:
Request : That calculate number of rows that have a same value in the `user_lang` and `user_useragent`:Code:----------------------------------------- # | 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 -----------------------------------------
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.








Bookmarks