悲催的SQLITE3，LIKE语句怎么都没有返回值……
表 PV 如下：

p_id,v_id,value
1|1|011
1|2|0111
2|1|011
2|2|01111
3|1|011
3|2|01
4|1|01
4|2|0111


SQL 语句如下：


CREATE VIEW V1 AS select L.p_id AS pa_id, R.p_id AS ch_id FROM PV as L inner join PV as R on L.v_id = R.v_id and L.p_id <> R.p_id where R.value LIKE '/['+ L.value+ '/]%' escape '/';


好像使用
LIKE 则一行也没有，
使用not like 全部返回来了

其中，value是TEXT属性，UTF-8编码

[解决办法]
用你的数据，要求结果是什么
[解决办法]

楼主啊，SQLITE文档中有说明啊，字符串连接用 ||


select L.p_id AS pa_id, R.p_id AS ch_id FROM PV as L inner join PV as R on L.v_id = R.v_id and L.p_id <> R.p_id
where R.value LIKE L.value||'%'