Hi List, I am using MySQL MAX 3.23 on a SuSE Linux System. But my problem is about SQL: Is there a "in the near of my result" statement that returns the surrounding rows, e.g. SELECT name FROM names WHERE name="foo" NEAR(-2,2) which results: ann marie foo bar john? I know, if my keys would be incremented numbers I could use BETWEEN or HAVING, but they aren't incremented (but numbers;-)). Now I solve this Problem by an external Program, but this is very slow for large tables. Any suggestions? Thanks a lot,
Jan (p.s. in core this MUST be a simple problem) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php