Specify field to start reading from

[abdoelmasry]

Hi
i need help in mysql
i want to specify field to start reading from
EX:
i have table contain this data:

id username password email country
1 abdo XXXX XXXX XXXXX
2 ahmed XXXX XXXX XXXXX
3 mido XXXX XXXX XXXXX
4 john XXXX XXXX XXXXX
5 samir XXXX XXXX XXXXX
6 mona XXXX XXXX XXXXX


when i use this command:
select * from user
it always read the table from the first value

i wanna specify place to start reading from
EX:
i want read data starting from id 3


i Home I could Explain

[Motoma]

There are a large number of ways to do this, you can use the LIMIT structure, or specify a WHERE clause.

SELECT * FROM user LIMIT 3, 5
SELECT * FROM user WHERE id > 2 
 

Hi
i need help in mysql
i want to specify field to start reading from
EX:
i have table contain this data:

id username password email country
1 abdo XXXX XXXX XXXXX
2 ahmed XXXX XXXX XXXXX
3 mido XXXX XXXX XXXXX
4 john XXXX XXXX XXXXX
5 samir XXXX XXXX XXXXX
6 mona XXXX XXXX XXXXX


when i use this command:
select * from user
it always read the table from the first value

i wanna specify place to start reading from
EX:
i want read data starting from id 3


i Home I could Explain

[abdoelmasry]

THank U Motoma
It Works Perfectly


Abdo Elmasry

[Motoma]

THank U Motoma
It Works Perfectly


Abdo Elmasry

Make sure you test your queries. Often when limiting, you want to use an ORDER BY as well, to ensure you get data in the correct order.

[abdoelmasry]

Ya Im using it with order by
and already have primary key for tables

Thank U