How can i get last row of specific id in mysql?

Question

I'm trying to get last row of specific id in mysql. Let suppose i have a table user products

    userProducts

    id | user_id  | products 
    1 | 12| Mouse
    2 | 12| Keyboard
    3 | 12| Laptop
    4 | 12| Headphone
    5 | 12| Webcame

I want to get last row Webcame of user_id=12. Please guide me how can i customize this query for that.

select * from userProducts where user_id = 12

Answer 1

You need to sort by id and limit resultset:

SELECT * 
FROM userProducts
WHERE user_id = 12
ORDER BY id  DESC
LIMIT 1

Answer 2

Add a subquery:

select * from userProducts 
where user_id = 12 
and id = (
 select max(id) from userProducts where user_id = 12
);