$sql = 'SELECT col_1 FROM theTable'; ..... while ($data = $sty->fetchrow_array()) { push @my_list, $data; }