How to get all but the first entries with duplicate users?

Question

MySQL

There is a table of the form It is uuid, user_id, update_at(timestamp)
necessary to get all the records in which it repeats user_idand in which update_at < MAX(update_at)with the current user_id

So far I figured out how to get records with repetitions, but I update_athaven’t figured out how to filter by yet

SELECT * FROM table WHERE user_id IN (SELECT user_id from table group by user_id having count(*) > 1)

Answer 1

SELECT DISTINCT `t1`.*
  FROM `table` AS `t1`
  JOIN `table` AS `t2`
    ON `t2`.`user_id` = `t1`.`user_id`
      AND `t2`.`update_at` > `t1`.`update_at`

Answer 2

Add to WHERE: AND update_at >= :date
And the actual value of the parameter is easiest to pull out with a separate request.