Let's say I have a single column table like this: Name ---------- Sam Daniel Artur Andrew Mark Thomas Ross Andrew Michelle Adrian Diane
I want to find the first occurrence of "Andrew", but also the neighboring rows (like the two rows above the first "Andrew" and the two rows below the first "Andrew"). This is an example of what I'd like the query to return: Daniel Artur Andrew Mark Thomas Please keep in mind this is just a demo to illustrate my question; this is not a real table example! Thanks a lot! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org