SQLite中的向后匹配(Backward matching in SQLite)

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> ^Z

This 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