CODE EXAMPLE FOR SQL

SQL

select * from bricks
where  colour = 'red'
for    update;