select * from t_house_person_relation as r where char_length(r.r_room_num)=3
select substring(r.r_room_num from 1 for 1) from t_house_person_relation as r where char_length(r.r_room_num)=3
update t_house_person_relation as r set r_floor=(select substring(r.r_room_num from 1 for 1))
where char_length(r.r_room_num)=3
select * from t_house_person_relation as r where char_length(r.r_room_num)=4
select substring(r.r_room_num from 1 for 2) from t_house_person_relation as r where char_length(r.r_room_num)=4
update t_house_person_relation as r set r_floor=(select substring(r.r_room_num from 1 for 2))
where char_length(r.r_room_num)=4