Select in mysql from such Input

Asked

Viewed 58 times

0

I am making a query in the database and have to return the table from such index. for example:

| Ind | value |
|001| AAA |
|002| BBB |
|003| CCC |
|004| DDD |
|005| EEA |
|006| FFF |
|007| GGG |
|008| HHH |

I would have to return the values of the Ind from 5 down (6,7,8);

1 answer

2


just make the following select

SELECT * FROM SUATABELA where ind >= '5'

If you do not want to display the 5 is like this

SELECT * FROM SUATABELA where ind > '5'

remembering that SUATABLE is the name of your table in db

Browser other questions tagged

You are not signed in. Login or sign up in order to post.