select the most used registrations in mysql
Posted: Fri Mar 20, 2009 6:57 am
Hi.
I don't know how to solve a problem in mysql.
I have this structure
Game_cod
------------
ID _ _ COD _ _ _ _ _ _ _ _ _ COD_AFERENT
1 _ _ 23,54,23,57,12,545 _ _ 1;1;10;2;1;12
2. _ _23,44,69,12,33,844 _ _0;1;02;0;3;3
etc
and i have to select the most used "cod" and then to find out the most used "cod_aferent".
Thanks.
I don't know how to solve a problem in mysql.
I have this structure
Game_cod
------------
ID _ _ COD _ _ _ _ _ _ _ _ _ COD_AFERENT
1 _ _ 23,54,23,57,12,545 _ _ 1;1;10;2;1;12
2. _ _23,44,69,12,33,844 _ _0;1;02;0;3;3
etc
and i have to select the most used "cod" and then to find out the most used "cod_aferent".
Thanks.