表 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||'%'