php - MySQL order by where greater than a phrase alphabetically? -

php - MySQL order by where greater than a phrase alphabetically? -

how can mysql select statement order name it's alphabetically greater grapes? * result should orange.

apple grapes orange pear pineapple

i can't order name. have order name starting after grapes.

you can using limit 1 , clause :

select name youtable name > 'grapes' order name limit 1

php mysql