SQL: populate a table column from another table

1. Populate column type in table1 table

2. Select a row with specified values from table2 table

3. "`" are used to mark the reserved words like value, type, etc.

update table1 as x set x.`type` = (select y.id from `table2` as y where y.entity = 'infinite loop' AND y.name = 'type' and y.`value` = 'regular');