How mysql to larger than the current numerical value next-CodePudding

Now have so a few records, if I came willnum=24, access to willnum=50 this record, if willnum=87 get the record to willnum=100,
If just willnum=50\100\150\200 access to the current record

CodePudding user response:

WHERE willnum> Can not yao={willnum}

CodePudding user response:

reference 1/f, three years 丿 response:

WHERE willnum> Can not yao={willnum}

So it not found out several records

CodePudding user response:

reference Romantic_321 reply: 3/f

Quote: reference 1/f, three years 丿 response:
WHERE willnum> Can not yao={willnum}

So it not found out several record

Then add an ORDER BY willnum LIMIT 1
Only the closest one

CodePudding user response:

3 years 丿 reference 4 floor response:

Quote: refer to the third floor Romantic_321 response:

Quote: reference 1/f, three years 丿 response:
WHERE willnum> Can not yao={willnum}

So it not found out several record

Then add an ORDER BY willnum LIMIT 1
Only the most close to a

I now is such, but I feel a little low