Query Help

[Hunter Hillegas <lists@xxxxxxxxxxxxxxxxx>]

I have a query that I am having a really hard time writing so I thought I
would ask for help.

I have a table like this:

rec_num int(5)
name varchar(100)
status varchar(100)
date_of_entry datetime

I'm trying to return 120 rows from this table... Here's the catch: if
records that would be futher out than 120 rows have a status of "In
Process", they should pre-empt results that are not, but only near the end
of the list... Perhaps the last 10-20 records.

Sorting needs to be by the date_of_entry.

What do you folks think is the best way to do this?

mySql 3.23


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <mysql-thread80895@xxxxxxxxxxxxxxx>
To unsubscribe, e-mail <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php