SELECT a1,a2,replace(a2, "豫ICP備16006180號-", "") a22,a3,a4,a5 FROM `aaab` order by a2;SELECT a1,a2,substring(a2, 22) a22,a3,a4,a5 FROM `aaab` order by a22; 轉載于:https://www.cnblogs.com/qianduan/p/6970308.html
原帖:http://stackoverflow.com/questions/339537/end-line-characters-from-lines-read-from-text-file-using-python 1. python删除有空值的行。 When reading lines from a text file using python, the end-line character often needs to be truncated before pro