How create mysql query that will show only before and after of one specific record?
===

i have a query that is order by alphabetical order

    select id, color_name from colors order by color_name


output

<pre>
| 4 | blue
| 1 | red
| 2 | violet
| 3 | yellow
</pre>

i want to query the before and after record of specific record. example:  red

desired output:

<pre>
| 4 | blue
| 1 | red
| 2 | violet
</pre>

thanks.




