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
Forum Updated to NodeBB v4.3 + New Features

Qt SQLITE Driver LIKE Clause

Scheduled Pinned Locked Moved Solved General and Desktop
3 Posts 2 Posters 203 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