Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2010
    Posts
    2

    Unanswered: Underscore in search string..

    Hi all,

    I need to search a string which having an underscore, using LIKE. Is there any escape character for underscore like backslash(\) in mysql..?

    Thx in advance

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    You can specify an escape character.

    LIKE predicate

    match-expression [NOT] LIKE pattern-expression [ESCAPE escape-expression]

  3. #3
    Join Date
    Jan 2010
    Posts
    2
    Thank you. It is solved....

Posting Permissions

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