LIMIT with Postgres

[Anon]

I use postgresql, and i try to use LIMIT in this command:

SELECT * FROM book WHERE title Like '%' LIMIT $limit, $start;

But this query return all elements of my table.

Can you help me?

Jean Sé

[smarlowe]

What's the $start for? The syntax for limit is a single number, and if you want an offset you add that keyword and then another number.

SELECT * FROM book WHERE title Like '%' LIMIT $limit;

OR

SELECT * FROM book WHERE title Like '%' LIMIT $limit offset $start;