Assuming a table such this:
| ID | messageID | userID |
|----|-------------|--------|
| 1 | 345 | 71 |
| 2 | 984 | 71 |
| 3 | 461 | 72 |
| 4 | 156 | 73 |
| 5 | 441 | 73 |
| 6 | 489 | 73 |
| 7 | 483 | 74 |
| 8 | 523 | 74 |
| 9 | 723 | 74 |

I need the second, third, fourth, etc messageID for each userID. So I
would get a results table such as:
| ID | messageID | userID |
|----|-------------|--------|
| 2 | 984 | 71 |
| 5 | 441 | 73 |
| 6 | 489 | 73 |
| 7 | 483 | 74 |
| 9 | 723 | 74 |

I've tried playing with count and group by and limit, but I've not
found a solution. I can easily get all the rows and then remove the
rows that I don't need in PHP, but I'd still like to know if an
all-MySQL solution is possible.

Thanks!

--
Dotan Cohen

http://gibberish.co.il
http://what-is-what.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com