Hello Giovanni, I just gave it a try. The order of the operands of the LIKE operator doesn't make any difference. I just tested it manually against my sqlite database. The returned results are identical.
Greetings, Michael ‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐ Am Montag, Oktober 14, 2019 9:15 AM schrieb Giovanni Bechis <giova...@paclan.it>: > On 10/12/19 4:46 PM, y38...@protonmail.com wrote: > > > SELECT (username||'@'||domain) FROM users WHERE ? LIKE mailbox > > I think it should read > SELECT (username||'@'||domain) FROM users WHERE mailbox LIKE ? > typo or error ? > > Giovanni