Professional Web Applications Themes

Caret problem - MySQL

I needed to locate rows that contained /[^\d] Whilst LIKE '%/[^%' worked fine LIKE '%/[^\d%' ESCAPE '' or even '%^\T%' found nothing. I tried escaping various parts, but if I had a character following the ^, nothing was found. Any ideas?...

  1. #1

    Default Caret problem

    I needed to locate rows that contained
    /[^\d]

    Whilst
    LIKE '%/[^%'
    worked fine
    LIKE '%/[^\d%' ESCAPE ''
    or even '%^\T%'
    found nothing.
    I tried escaping various parts, but if I had a character following the ^,
    nothing was found.

    Any ideas?


    Paul Guest

  2. #2

    Default Re: Caret problem

    Paul Lautman wrote: 
    did you try lower case t in '%^\t%'

    also try using back ticks ` to see if you notice any difference. it's
    the character below ~
    lark Guest

  3. #3

    Default Re: Caret problem

    On 14 May, 14:32, lark <net> wrote: 


    >[/ref]
    | did you try lower case t in '%^\t%'
    Why woluld I want a ower case t? 
    | also try using back ticks ` to see if you notice any difference.
    it's
    | the character below ~
    On your keyboard it may be but not on mine.

    And I thought that back ticks were reserved for quoting identifiers,
    so why would I want to quote a literal with backticks?

    Please explain

    Captain Guest

  4. #4

    Default Re: Caret problem

    On Sun, 13 May 2007 22:23:14 +0100, "Paul Lautman"
    <com> wrote:
     

    LIKE '%/[^\\\\d]%' ?
    subtenante Guest

  5. #5

    Default Re: Caret problem

    On 14 May, 15:43, subtenante <com> wrote: 


    >
    > LIKE '%/[^\\\\d]%' ?[/ref]

    I'll try that later and let you know.

    Captain Guest

  6. #6

    Default Re: Caret problem

    Captain Paralytic wrote: [/ref]
    > | did you try lower case t in '%^\t%'
    > Why woluld I want a ower case t?
    > | also try using back ticks ` to see if you notice any difference.
    > it's
    > | the character below ~
    > On your keyboard it may be but not on mine.
    >
    > And I thought that back ticks were reserved for quoting identifiers,
    > so why would I want to quote a literal with backticks?
    >
    > Please explain
    >[/ref]
    you're right! back ticks are only for quoting identifiers!

    --
    lark -- net
    To reply to me directly, delete "despam".
    lark Guest

  7. #7

    Default Re: Caret problem

    On 14 May 2007 07:50:34 -0700, Captain Paralytic
    <com> wrote:
     
    >>
    >> LIKE '%/[^\\\\d]%' ?[/ref]
    >
    >I'll try that later and let you know.[/ref]

    I'm curious. Did it work ?
    subtenante Guest

Similar Threads

  1. Caret Position
    By ggleinig in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: October 31st, 05:09 PM
  2. Anyone set caret size/style in text field ?
    By ChipOfTheOldBlock in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: September 15th, 02:49 AM
  3. Changing caret size?
    By lynn_baker@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 0
    Last Post: August 16th, 03:43 PM
  4. Setting caret position within a text area
    By mikejan in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: February 13th, 09:40 PM
  5. Replies: 2
    Last Post: July 17th, 07:27 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139