UPDATE cqlp_home_info SET Title=replace(Title,'最低价','') WHERE Title LIKE '%最低价%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'最低价','') WHERE HouseAddress LIKE '%最低价%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'最低价','') WHERE MoreNote LIKE '%最低价%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'最低价','') WHERE MoreNote1 LIKE '%最低价%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'最低价','') WHERE MoreNote2 LIKE '%最低价%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'最低价','') WHERE MoreNote3 LIKE '%最低价%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'最低价','') WHERE MoreNote4 LIKE '%最低价%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'西师附中','') WHERE Title LIKE '%西师附中%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'西师附中','') WHERE HouseAddress LIKE '%西师附中%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'西师附中','') WHERE MoreNote LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'西师附中','') WHERE MoreNote1 LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'西师附中','') WHERE MoreNote2 LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'西师附中','') WHERE MoreNote3 LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'西师附中','') WHERE MoreNote4 LIKE '%西师附中%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'名额','') WHERE Title LIKE '%名额%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'名额','') WHERE HouseAddress LIKE '%名额%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'名额','') WHERE MoreNote LIKE '%名额%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'名额','') WHERE MoreNote1 LIKE '%名额%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'名额','') WHERE MoreNote2 LIKE '%名额%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'名额','') WHERE MoreNote3 LIKE '%名额%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'名额','') WHERE MoreNote4 LIKE '%名额%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'学位','') WHERE Title LIKE '%学位%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'学位','') WHERE HouseAddress LIKE '%学位%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'学位','') WHERE MoreNote LIKE '%学位%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'学位','') WHERE MoreNote1 LIKE '%学位%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'学位','') WHERE MoreNote2 LIKE '%学位%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'学位','') WHERE MoreNote3 LIKE '%学位%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'学位','') WHERE MoreNote4 LIKE '%学位%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'中学','') WHERE Title LIKE '%中学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'中学','') WHERE HouseAddress LIKE '%中学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'中学','') WHERE MoreNote LIKE '%中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'中学','') WHERE MoreNote1 LIKE '%中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'中学','') WHERE MoreNote2 LIKE '%中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'中学','') WHERE MoreNote3 LIKE '%中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'中学','') WHERE MoreNote4 LIKE '%中学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'新校区','') WHERE Title LIKE '%新校区%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'新校区','') WHERE HouseAddress LIKE '%新校区%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'新校区','') WHERE MoreNote LIKE '%新校区%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'新校区','') WHERE MoreNote1 LIKE '%新校区%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'新校区','') WHERE MoreNote2 LIKE '%新校区%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'新校区','') WHERE MoreNote3 LIKE '%新校区%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'新校区','') WHERE MoreNote4 LIKE '%新校区%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'实验','') WHERE Title LIKE '%实验%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'实验','') WHERE HouseAddress LIKE '%实验%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'实验','') WHERE MoreNote LIKE '%实验%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'实验','') WHERE MoreNote1 LIKE '%实验%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'实验','') WHERE MoreNote2 LIKE '%实验%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'实验','') WHERE MoreNote3 LIKE '%实验%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'实验','') WHERE MoreNote4 LIKE '%实验%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'西苑','') WHERE Title LIKE '%西苑%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'西苑','') WHERE HouseAddress LIKE '%西苑%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'西苑','') WHERE MoreNote LIKE '%西苑%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'西苑','') WHERE MoreNote1 LIKE '%西苑%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'西苑','') WHERE MoreNote2 LIKE '%西苑%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'西苑','') WHERE MoreNote3 LIKE '%西苑%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'西苑','') WHERE MoreNote4 LIKE '%西苑%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'小学','') WHERE Title LIKE '%小学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'小学','') WHERE HouseAddress LIKE '%小学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'小学','') WHERE MoreNote LIKE '%小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'小学','') WHERE MoreNote1 LIKE '%小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'小学','') WHERE MoreNote2 LIKE '%小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'小学','') WHERE MoreNote3 LIKE '%小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'小学','') WHERE MoreNote4 LIKE '%小学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'西苑小学','') WHERE Title LIKE '%西苑小学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'西苑小学','') WHERE HouseAddress LIKE '%西苑小学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'西苑小学','') WHERE MoreNote LIKE '%西苑小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'西苑小学','') WHERE MoreNote1 LIKE '%西苑小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'西苑小学','') WHERE MoreNote2 LIKE '%西苑小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'西苑小学','') WHERE MoreNote3 LIKE '%西苑小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'西苑小学','') WHERE MoreNote4 LIKE '%西苑小学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'职教中心','') WHERE Title LIKE '%职教中心%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'职教中心','') WHERE HouseAddress LIKE '%职教中心%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'职教中心','') WHERE MoreNote LIKE '%职教中心%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'职教中心','') WHERE MoreNote1 LIKE '%职教中心%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'职教中心','') WHERE MoreNote2 LIKE '%职教中心%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'职教中心','') WHERE MoreNote3 LIKE '%职教中心%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'职教中心','') WHERE MoreNote4 LIKE '%职教中心%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'学校','') WHERE Title LIKE '%学校%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'学校','') WHERE HouseAddress LIKE '%学校%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'学校','') WHERE MoreNote LIKE '%学校%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'学校','') WHERE MoreNote1 LIKE '%学校%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'学校','') WHERE MoreNote2 LIKE '%学校%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'学校','') WHERE MoreNote3 LIKE '%学校%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'学校','') WHERE MoreNote4 LIKE '%学校%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'梁山小学','') WHERE Title LIKE '%梁山小学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'梁山小学','') WHERE HouseAddress LIKE '%梁山小学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'梁山小学','') WHERE MoreNote LIKE '%梁山小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'梁山小学','') WHERE MoreNote1 LIKE '%梁山小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'梁山小学','') WHERE MoreNote2 LIKE '%梁山小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'梁山小学','') WHERE MoreNote3 LIKE '%梁山小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'梁山小学','') WHERE MoreNote4 LIKE '%梁山小学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'西南大学附中','') WHERE Title LIKE '%西南大学附中%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'西南大学附中','') WHERE HouseAddress LIKE '%西南大学附中%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'西南大学附中','') WHERE MoreNote LIKE '%西南大学附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'西南大学附中','') WHERE MoreNote1 LIKE '%西南大学附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'西南大学附中','') WHERE MoreNote2 LIKE '%西南大学附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'西南大学附中','') WHERE MoreNote3 LIKE '%西南大学附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'西南大学附中','') WHERE MoreNote4 LIKE '%西南大学附中%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'实验小学','') WHERE Title LIKE '%实验小学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'实验小学','') WHERE HouseAddress LIKE '%实验小学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'实验小学','') WHERE MoreNote LIKE '%实验小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'实验小学','') WHERE MoreNote1 LIKE '%实验小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'实验小学','') WHERE MoreNote2 LIKE '%实验小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'实验小学','') WHERE MoreNote3 LIKE '%实验小学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'实验小学','') WHERE MoreNote4 LIKE '%实验小学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'红旗中学','') WHERE Title LIKE '%红旗中学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'红旗中学','') WHERE HouseAddress LIKE '%红旗中学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'红旗中学','') WHERE MoreNote LIKE '%红旗中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'红旗中学','') WHERE MoreNote1 LIKE '%红旗中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'红旗中学','') WHERE MoreNote2 LIKE '%红旗中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'红旗中学','') WHERE MoreNote3 LIKE '%红旗中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'红旗中学','') WHERE MoreNote4 LIKE '%红旗中学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'梁平中学','') WHERE Title LIKE '%梁平中学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'梁平中学','') WHERE HouseAddress LIKE '%梁平中学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'梁平中学','') WHERE MoreNote LIKE '%梁平中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'梁平中学','') WHERE MoreNote1 LIKE '%梁平中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'梁平中学','') WHERE MoreNote2 LIKE '%梁平中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'梁平中学','') WHERE MoreNote3 LIKE '%梁平中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'梁平中学','') WHERE MoreNote4 LIKE '%梁平中学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'梁中','') WHERE Title LIKE '%梁中%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'梁中','') WHERE HouseAddress LIKE '%梁中%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'梁中','') WHERE MoreNote LIKE '%梁中%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'梁中','') WHERE MoreNote1 LIKE '%梁中%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'梁中','') WHERE MoreNote2 LIKE '%梁中%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'梁中','') WHERE MoreNote3 LIKE '%梁中%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'梁中','') WHERE MoreNote4 LIKE '%梁中%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'实验中学','') WHERE Title LIKE '%实验中学%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'实验中学','') WHERE HouseAddress LIKE '%实验中学%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'实验中学','') WHERE MoreNote LIKE '%实验中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'实验中学','') WHERE MoreNote1 LIKE '%实验中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'实验中学','') WHERE MoreNote2 LIKE '%实验中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'实验中学','') WHERE MoreNote3 LIKE '%实验中学%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'实验中学','') WHERE MoreNote4 LIKE '%实验中学%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'西小','') WHERE Title LIKE '%西小%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'西小','') WHERE HouseAddress LIKE '%西小%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'西小','') WHERE MoreNote LIKE '%西小%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'西小','') WHERE MoreNote1 LIKE '%西小%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'西小','') WHERE MoreNote2 LIKE '%西小%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'西小','') WHERE MoreNote3 LIKE '%西小%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'西小','') WHERE MoreNote4 LIKE '%西小%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'西师附中','') WHERE Title LIKE '%西师附中%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'西师附中','') WHERE HouseAddress LIKE '%西师附中%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'西师附中','') WHERE MoreNote LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'西师附中','') WHERE MoreNote1 LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'西师附中','') WHERE MoreNote2 LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'西师附中','') WHERE MoreNote3 LIKE '%西师附中%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'西师附中','') WHERE MoreNote4 LIKE '%西师附中%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'南小','') WHERE Title LIKE '%南小%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'南小','') WHERE HouseAddress LIKE '%南小%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'南小','') WHERE MoreNote LIKE '%南小%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'南小','') WHERE MoreNote1 LIKE '%南小%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'南小','') WHERE MoreNote2 LIKE '%南小%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'南小','') WHERE MoreNote3 LIKE '%南小%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'南小','') WHERE MoreNote4 LIKE '%南小%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'红中','') WHERE Title LIKE '%红中%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'红中','') WHERE HouseAddress LIKE '%红中%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'红中','') WHERE MoreNote LIKE '%红中%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'红中','') WHERE MoreNote1 LIKE '%红中%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'红中','') WHERE MoreNote2 LIKE '%红中%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'红中','') WHERE MoreNote3 LIKE '%红中%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'红中','') WHERE MoreNote4 LIKE '%红中%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'一中','') WHERE Title LIKE '%一中%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'一中','') WHERE HouseAddress LIKE '%一中%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'一中','') WHERE MoreNote LIKE '%一中%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'一中','') WHERE MoreNote1 LIKE '%一中%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'一中','') WHERE MoreNote2 LIKE '%一中%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'一中','') WHERE MoreNote3 LIKE '%一中%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'一中','') WHERE MoreNote4 LIKE '%一中%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'附小','') WHERE Title LIKE '%附小%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'附小','') WHERE HouseAddress LIKE '%附小%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'附小','') WHERE MoreNote LIKE '%附小%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'附小','') WHERE MoreNote1 LIKE '%附小%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'附小','') WHERE MoreNote2 LIKE '%附小%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'附小','') WHERE MoreNote3 LIKE '%附小%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'附小','') WHERE MoreNote4 LIKE '%附小%'<br>UPDATE cqlp_home_info SET Title=replace(Title,'学区','') WHERE Title LIKE '%学区%'<br>UPDATE cqlp_home_info SET HouseAddress=replace(HouseAddress,'学区','') WHERE HouseAddress LIKE '%学区%'<br>UPDATE cqlp_home_info SET MoreNote=replace(MoreNote,'学区','') WHERE MoreNote LIKE '%学区%'<br>UPDATE cqlp_home_newfloor SET MoreNote1=replace(MoreNote1,'学区','') WHERE MoreNote1 LIKE '%学区%'<br>UPDATE cqlp_home_newfloor SET MoreNote2=replace(MoreNote2,'学区','') WHERE MoreNote2 LIKE '%学区%'<br>UPDATE cqlp_home_newfloor SET MoreNote3=replace(MoreNote3,'学区','') WHERE MoreNote3 LIKE '%学区%'<br>UPDATE cqlp_home_newfloor SET MoreNote4=replace(MoreNote4,'学区','') WHERE MoreNote4 LIKE '%学区%'<br>