悲催的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编码