Re: Help with table structure and function

[Phillip Ward]

Since the only [completely reliable] way to get rows in the order you want them is to use an "order by" clause, you need to add another column for that clause to work on:

select * from mytable 
order by seq ; 

+----+-----+---------+ 
| id | seq | name    | 
+----+-----+---------+ 
|  1 |   1 | reddit  | 
|  4 |   2 | youtube | 
|  2 |   3 | google  | 
|  3 |   4 | yahoo   | 
+----+-----+---------+

Regards, Phill W.