Qt SQLITE Driver LIKE Clause
-
wrote on 27 Aug 2022, 00:12 last edited by
Is someone able to confirm whether or not the Qt SQLITE driver supports square bracket wildcards when employing the LIKE clause?
For example, whilst the following appears to work as expected:
..... LIKE '%Hello%'The following does not:
..... LIKE '%[^a-z]Hello[^a-z]%'
From what I'm able to deduce, the square brakets are not interpreted as wildcards at all.
Any advice would be very much appreciated.
-
wrote on 27 Aug 2022, 05:22 last edited by A.A.SEZEN
Search for GLOB, REGEXP sqlite keywords instead of LIKE for the characters and operators you want to use.
-
wrote on 27 Aug 2022, 08:52 last edited by
Perfect!
Thank you for your assistance; problem solved :)
1/3