need help (not an issue)

[baxterj1978]

Can someone help with this? I have tried everything I can think of, but how do you assign specific rows of data and their column's values into variables in Swift that can actually be used?
the simplest example I have is

let res = try con.query("SELECT * FROM prate")
let rows = try res.readAllRows()
print(rows)
ive done this and other ways to query and they all just give back the whole record.
how do i assign it to be something like the following?
let res = try con.query("SELECT * FROM prate")
var column1 = res.column(column1.string)
var column2 = res.column(column2.value)

thanks. i am totally stuck on this

[k-marinov]

        // prepare a new statement for select
        let select_stmt = try con.prepare("SELECT * FROM users limit 2")

        let res = try select_stmt.query([])

        //read all rows from the resultset
        let rows: [MySQL.ResultSet]? = try res.readAllRows()

        print( rows?.first?.first?["name"])