Is there a MySQL equivalent for "FOR UPDATE SKIP LOCKED"? That's a feature that I've fallen in love with because it has completely eradicated the need to have a message queue like RabbitMQ or whatever. For example, for distributing jobs to background workers, I just insert them into a jobs table and have the workers poll for jobs with:

  DELETE FROM jobs WHERE id = (
    SELECT id FROM jobs FOR UPDATE SKIP LOCKED
  ) RETURNING *;

Then just commit the respective transaction on success or rollback on failure. Would this look as simple as that in MySQL?