SQL Output each row?

I couldn’t find any post telling me how to, when I have a table with a couple of rows, output each of the rows

This is what I’ve got so far:

result = sql.Query(“SELECT message FROM mytable”)

for k, v in pairs( result ) do

But it just outputs the first row everytime.

I hope someone can help me!