mysql offset and limit code example

Example 1: limit offset order by mysql

SELECT 
    column_list
FROM
    table1
ORDER BY column_list
LIMIT row_count OFFSET offset;

Example 2: limit offset

SELECT * FROM artists LIMIT 5 OFFSET [Number of rows to skip];