Problem with LIKE/REGEXP

2003-11-05 Thread George Moschovitis
m since the following produces matches: SELECT oid FROM mytab WHERE odata LIKE "[EMAIL PROTECTED]"_athens1234%"; I tried using a MEDIUMTEXT and/or REGEXP but without success! Any idea how to do string matches on string-encoded binary data? Thanks in advance for any info! George

Re: Problem with LIKE/REGEXP

2003-11-05 Thread George Moschovitis
Here is some additional information: I tried with version 3.23 and version 4.0 And I am using MyISAM tables. This is not a full text search an there is no index on the column. any ideas? George Moschovitis -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

RE: Problem with LIKE/REGEXP

2003-11-06 Thread George Moschovitis
> What are you actually trying to match with \017? As far as I know, it's > treating the \0 part as a NUL byte and trying to match that. Are you > trying to match a NUL byte? Or are you trying to match ASCII 17 or > something? Hello matt, i am trying to match a binary string (with binary data) ag