how to get medium thumbnail from mysql database

How do you get a medium sized thumbnail using a sql query. Right now i have managed to get the largest thumbnail out of the database but its too big and want the medium sized one to be displayed.

Any ideas?

Thanks