How can i reduce the amount of table rows returned

[Administrator]

You can reduce the amount of data returned from a database query by using LIMIT

Code: Select all

SELECT * FROM `table_name`
LIMIT 1

you can also supply a OFFSET for a pagination like effect