Sqlite数据库字符串处理函数replace 

replace(X,Y,Z)	 
The replace(X,Y,Z) function returns a string formed by substituting string Z for every occurrence of string Y in string X. The BINARY collating sequence is used for comparisons. If Y is an empty string then return X unchanged. If Z is not initially a string, it is cast to a UTF-8 string prior to processing.
x:要处理的字符串
y:被替换的字符串
z:替换后的字符串
有图有真相

参考：






posted @ 2014-10-20 16:24  HTL  阅读(23568)  评论(0)  编辑  收藏  举报
htl