Sqlite資料庫字串處理函數replace

標籤：blog   http   io   ar   for   sp   資料   div   2014   

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:替換後的字串有圖有真相

參考：
Sqlitereplace官方說明CSDN Sqlite3中replace語句用法詳解Cnblogs.com 在Sqlite中通過Replace來實現插入和更新



來自為知筆記(Wiz)

Sqlite資料庫字串處理函數replace