Re: Displaying designated record first in a SELECT result

[Andrew Gilfrin]

Would limit do the trick?

mysql> select * from emps limit 1;
+--------+----------+---------+-----------+---------+---------+
| emp_id | emp_name | dept_id | dept_name | salary | user_id |
+--------+----------+---------+-----------+---------+---------+
| 1 | Roger | 1 | NULL | 2000.00 | NULL |
+--------+----------+---------+-----------+---------+---------+
1 row in set (0.01 sec)

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information