SQL Output each row?

Hello,
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
print(v[‘message’])
end

But it just outputs the first row everytime.

I hope someone can help me!
-Wip