select DATE_FORMAT(c.date, '%W %M %Y') c.name from cd as c, track as trk where trk.album_id=c.id AND trk.name='Darkness On The Edge Of Town'
any ideas?
Moderator: General Moderators
Code: Select all
SELECT DATE_FORMAT(c.date, '%W %M %Y') AS date, c.name FROM cd AS c, track AS trk WHERE trk.album_id=c.id AND trk.name='Darkness On The Edge Of Town'