Tricky select - if even possible

[senseipt]

I'm working on a request system to work with a database used by Streaming Audio Manager (SAM2) where data such as album name, track title, artist etc is stored. Now, the problem is that the guy who made it didn't make much of a relational database so it's all in one huge table called SAMDB. I want to make a list of all the letters so that when a user clicks on e.g. A all albums starting with A is listed. If this db had been a bit different I could have done it easily, but the way it is now I have no idea how I can list all albums by their first letter. Anyone got a suggestion? Here's some graphich candy for you just to examplify things:





Thanks,
Sensei

[r937]

select artist, title, album
from samdb
where album like 'A%'
order by album

[senseipt]

Thanks for your quick answer, but as I feared when I echo out the album name after that SELECT it prints the name the same number of times that it is saved in the db. Sorry if I didn't specify that I only wanted it to be printed once. How do I limit it?

Thanks,
Sensei

[r937]

if you mean you want this data --

bob marley   a touch of reggae  lively up yourself
bob marley   soul rebel         fussin' fightin'
bob marley   natural mystic     soon come

to be listed like this --

bob marley
   a touch of reggae  lively up yourself
   soul rebel         fussin' fightin'
   natural mystic     soon come

then the answer is, you have to do that in your calling script