SQL return all rows in column

[Cpt Rawr]

Hi,

How would I return all the rows in a column?

https://files.facepunch.com/forum/upload/111841/84feea44-9636-4e2e-b4aa-c6231f9f0cbc/image.png

I would like to get all the rows from column "One", preferably as a table,

{1, 2, 3, 4}

Any help is appreciated

Thanks

[Maud Pie]

You can try to use for loop and make ur table

[bigdogmat]

local results = sql.Query "SELECT col1 FROM table"

if results then
  for _, data in ipairs(results) do
    print(data.col1)
  end
end

If you require it to be in a sequential format you can build the table yourself from the above.

[Cpt Rawr]

This works thank you