SQLite中的向后匹配(Backward matching in SQLite)
我需要在SQLite中编写后向匹配查询。 有什么办法吗?
我的例子如下:
SELECT * FROM urls where forwordurl LIKE '%www.google.com%'这工作正常, 但我需要吼叫
SELECT * FROM urls where 'www.google.com' LIKE %forwordurl%有什么办法吗?
I need to write backward matching query in SQLite. Is there any way to do it?
My example is bellow:
SELECT * FROM urls where forwordurl LIKE '%www.google.com%'that works fine, but i need to as bellow
SELECT * FROM urls where 'www.google.com' LIKE %forwordurl%Is there any way to do it?
最满意答案
这有效:
SELECT * FROM urls WHERE 'www.google.com' LIKE '%' || forwordurl || '%'例:
[C:\Temp] :sqlite3 test.db SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table urls (forwordurl text); sqlite> insert into urls (forwordurl) values ('google'); sqlite> select * from urls where 'www.google.com' like '%' || forwordurl || '%'; google sqlite> ^ZThis works:
SELECT * FROM urls WHERE 'www.google.com' LIKE '%' || forwordurl || '%'Example:
[C:\Temp] :sqlite3 test.db SQLite version 3.6.20 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create table urls (forwordurl text); sqlite> insert into urls (forwordurl) values ('google'); sqlite> select * from urls where 'www.google.com' like '%' || forwordurl || '%'; google sqlite> ^Z更多推荐
发布评论