mysql - sql select to start from id [closed]

Question

How can I start a SQL query from a specific ID...

id | name  |
------------
1  | Joe   |

2  | Craig |

3  | Shawn |

4  | Ryan  |

5  | Seth  |

I want to start from ID 3

$strSQL = "SELECT * FROM table_name WHERE id >= 3";

Thanks for any help!

Answer 1

use also ORDER BY for right order

SELECT * FROM table_name WHERE id >= 3 ORDER BY id ASC

Answer 2

use order by like this

$strSQL = "SELECT * FROM table_name WHERE id>=3 ORDERT BY id;