在sqlite中删除9D(十六进制)字符 [英] 9D (Hex) character remove in sqlite

问题描述

我想从 my_table 中选择 family，其中 family LIKE '%HEX(9D)'家庭十六进制格式以 9D 十六进制结尾我将excel文件转换为sqlite数据库但是我的一些数据最后添加了 9D我无法正确搜索请指导我如何删除家族列中的 9D 十六进制字符?

i want select family from my_table where family LIKE '%HEX(9D)' family hex format ended with 9D hex i convert excel file in to sqlite database but some of my data add 9D in ended i can not search correctly please guide me how can remove 9D hex character in family column?

推荐答案

要在 SQLLite 中获得 HEX(9D) 使用 cast(X'9D' as text).所以要更新使用类似的东西:

To get HEX(9D) in SQLLite use cast(X'9D' as text). So to update use something like:

UPDATE YOURTABLE SET YOURCOLUMN=REPLACE(YOURCOLUMN,cast(X'9D' as text),'') where YOURCOLUMN like '%'||cast(X'9D' as text)||'%';

或者只是

UPDATE YOURTABLE SET YOURCOLUMN=REPLACE(YOURCOLUMN,X'9D','') where YOURCOLUMN like '%'||x'9D'||'%';

这篇关于在sqlite中删除9D(十六进制)字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！