s4salman Posted September 27, 2008 Share Posted September 27, 2008 Hello i have a mysql table namee 'lyrics'.It has so many lyrics in albums.Means for example there are 10 lyrics in one album.Table structure is as follows : id|title|artist|album|lyrics What i want to do is to print album name only once.Although it has been 1000 times repeated in the table with different lyrics. Hope you understand what i explain here. Please can anybody tell me how to do that? SQL sataement should i use ? Thanks Link to comment https://forums.phpfreaks.com/topic/126027-distinctive-records/ Share on other sites More sharing options...
ratcateme Posted September 27, 2008 Share Posted September 27, 2008 try SELECT DISTINCT `album` FROM `lyrics`; Scott. Link to comment https://forums.phpfreaks.com/topic/126027-distinctive-records/#findComment-651753 Share on other sites More sharing options...
s4salman Posted September 27, 2008 Author Share Posted September 27, 2008 thank you for your help. Link to comment https://forums.phpfreaks.com/topic/126027-distinctive-records/#findComment-651818 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.