Posted by Ian B on 10/20/05 03:11

Not quite what you asked for but

select num, abs(num - $reqd ) as srt from t1 order by srt limit 11

will give you your record plus the nearest 10 records to it

Just a thought.

Ian

• Next in forum: Re: No redirection? Please help.
• Prev in forum: Re: user hierarchy
• Thread view: Re: SELECT * help needed.

[Reply to this message]