Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Qt SQLITE Driver LIKE Clause

Qt SQLITE Driver LIKE Clause

Scheduled Pinned Locked Moved Solved General and Desktop
3 Posts 2 Posters 259 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • T Offline
    T Offline
    Taliadon
    wrote on last edited by
    #1

    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.

    1 Reply Last reply
    0
    • A.A.SEZENA Offline
      A.A.SEZENA Offline
      A.A.SEZEN
      wrote on last edited by A.A.SEZEN
      #2

      Search for GLOB, REGEXP sqlite keywords instead of LIKE for the characters and operators you want to use.

      1 Reply Last reply
      4
      • T Offline
        T Offline
        Taliadon
        wrote on last edited by
        #3

        Perfect!

        Thank you for your assistance; problem solved :)

        1 Reply Last reply
        0

        • Login

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Users
        • Groups
        • Search
        • Get Qt Extensions
        • Unsolved