mysql> select id,title,album_id from gallery_img WHERE user_id=1; +----+------------+----------+ | id | title | album_id | +----+------------+----------+ | 1 | drink | 1 | | 2 | seda | 2 | | 3 | seda1 | 2 | | 4 | seda1333 | 2 | | 5 | sdfsdf | 2 | | 6 | sdfsdfw | 2 | | 7 | asdfsdfw | 2 | | 8 | asdfsdfwq | 2 | | 9 | 123 | 2 | | 10 | fsdfsdf | 2 | | 11 | fsdfsdf123 | 2 | | 12 | fsdfsdf123 | 2 | | 13 | logo | 1 | +----+------------+----------+ 13 rows in set (0.00 sec) mysql> select id,title,album_id from gallery_img WHERE user_id=1 GROUP BY album_id; +----+-------+----------+ | id | title | album_id | +----+-------+----------+ | 1 | drink | 1 | | 2 | seda | 2 | +----+-------+----------+ 2 rows in set (0.00 sec)