Is there any way in the SQL language (and using BD mysql) where I can start a Select in the middle of a table?
For example, I have 500 addresses in the table. I search the addresses of Bairro X (where neighborhood="x"), reducing the total to, say, 60 addresses. But I wanted to start listing from half of those 60 onwards, ignoring the previous ones (even though they are from the neighborhood "x"). How?
Another issue is that I do not know how many values I will have depending on the neighborhood selected, so it may vary. 60, 68, 90, etc. Is there a function inside SQL that makes the select list start in the middle (or at any point, for example, 1/3, 2/3, 5/6 etc) of a select + where result?