A column expression is not accepted in LIKE condition
Steps to Reproduce
I have a table containing strings that are patterns (they contain wildcards like % and _). I need to get only the rows where this pattern column match a string literal
This is a query example that is working in sqlite:
SELECT * FROM request_limit where 'https://api.ibkr.com/v1/api/iserver/account/order/status/123' like target;
I am trying to reproduce this query with the following code:
Description
A column expression is not accepted in LIKE condition
Steps to Reproduce
I have a table containing strings that are patterns (they contain wildcards like % and _). I need to get only the rows where this pattern column match a string literal This is a query example that is working in sqlite:
I am trying to reproduce this query with the following code:
Expected Behavior
Compiles successfully
Actual Behavior
I get an error: