Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2001
    Location
    South Africa
    Posts
    33

    Unanswered: select quandry ...

    please help -- I need a sql query that can do the follwing:

    select * from table where col1 like hex("somestring")

    How do I get the "%" in there ???

    THNAKS

  2. #2
    Join Date
    Nov 2001
    Location
    South Africa
    Posts
    33

    Re: select quandry ...

    Neva mind - figured it out

    select * from table where concat("%", hex('somestring'), "%");

    Thanks

Posting Permissions

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