SQLite Forum

Something like:<code>
  UPDATE feeder SET quantity = quantity + 1
  WHERE id in (
    SELECT id from feeder
    WHERE quantity < 200 AND available = 1
    LIMIT 1
  )
  RETURNING id, food_weigth, quantity
</code>