MYSQL and TOP usage in SELECT statement

Question

Does MYSQL allow for the use of TOP in the select statement?

SELECT TOP 2 id
From product

Answer 1

In MySQL it's called LIMIT and goes near the end of the query:

SELECT id
FROM product
LIMIT 2

Manual: SELECT statement, LIMIT clause

Answer 2

MySQL equivalent to TOP is LIMIT.

So your query would be

SELECT ID FROM PRODUCT LIMIT 2