Re: Select and update at the same time (with selected value)?

[Kevin K]

@Laptop Alias: That's not what I am looking for.
@Rick James (hi again): I'm not sure the LAST_INSERT_ID() is what I'm looking for either.

My guess is my statement would look something akin to:

select * from pool_process where any="1" and status="" order by id asc limit 1 and update pool_process set status = "RUNNING" where id = this.id;