Hi,

As my mysql command line utility aborts when searching for certain characters in a binary field (it affects bash as well), I decided to convert these characters via CHAR(character) instead, like this:

select binary_column from my_table where binary_column like CONCAT (CHAR(3),'pR',CHAR(1),CHAR(3),'pU',CHAR(1),'%')


This works fine, but it looks a little clunky. Is there another way to write this query more efficiently?


Thanks for feedback!


Richard Taubo

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to