Quick rundown.
Table:
Assignments
CaseID auto_increment
FileNumber char(18)
FirstName char(20)
LastName char(20)
and on and on and on
Indexes on
CaseID (Primary)
FileNumber
Name (LastName, FirstName)
What I would like to do is something along the lines of
SELECT CaseID FROM Assignments WHERE FileNumber = '111-2332-12232-299' ORDER
BY FileNumber;
But I want to pull up the previous 10 and next 10 Cases (Loading the list of
CaseID's is starting to slow down the program). I looked at LIMIT but don't
know how to use that to do what I want.
Failing that, I would like to be able to do something along the lines of
SELECT NEXT CaseID FROM Assignments .....
After the initial pull.
Any help/suggestions would be greatly appreciated.
Thanx
Roger
SQL/MYSQL
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
