OFFSET is not working in MySQL query

Question

OFFSET is not working

SELECT
  iContentID,
  vTitle,
  vContectNo
FROM
  `tbl_contact_list`
WHERE
  `eStatus` = Active AND `eDeleted` = 0
ORDER BY
  `vTitle` ASC OFFSET 0

Getting below error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'offset 0' at line 1

phpmyadmin Version information: 4.0.10deb1
database Server version: 5.5.54-0ubuntu0.14.04.1 - (Ubuntu)
PHP version 7

Ken Y-N · Accepted Answer · 2017-10-12 07:57:14Z

3

Looking at the syntax for SELECT:

[LIMIT {[offset,] row_count | row_count OFFSET offset}]

You need a LIMIT first to specify the maximum number of rows to return.

See also this question for more details on usage.

(BTW, OFFSET 0 is unnecessary as it is the default)

answered Oct 12, 2017 at 7:57

Ken Y-N

15.2k22 gold badges80 silver badges122 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

OFFSET is not working in MySQL query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related