row_number() window function

[poipoi244]

I'm currently having problem with the row_number() window function (got syntax error, the error message is pretty identical to the issue i have read on prisma here). I'm wondering if mysql2 supports this functionality? If so, could you provide an example of how I might modify the following SQL statement to work with mysql2.

Thank you in advance! c:

SELECT ROW_NUMBER() OVER (
    PARTITION BY column_name ORDER BY column_name) AS rn, column_name 
FROM table_name;