MySQL Forums
Forum List  »  Newbie

Re: Reading table beginning at the middle
Posted by: Mike Lambert
Date: February 11, 2021 07:13PM

Thank you Peter ...

If my table contains
AAAAAA
CCCCCC
and if I access it using key BBBBBB I want to get the value AAAAAA.

If my table contains
AAAAAA
BBBBBB
CCCCCC

and if I access it using key BBBBBB I want to get the value BBBBBB.

From your example I can see that I can access via 2 selects ... one for equal to key and one for < but can I do it with one statement ?

I hope I have made myself clearer.

Mike

Options: ReplyQuote


Subject
Written By
Posted
Re: Reading table beginning at the middle
February 11, 2021 07:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.