in reply to how do get value of mysql column

depending on the number of rows you expect to be returned, and what you're doing with them (among other things), you may find the fetchall_* or selectall_* DBI methods are useful.