If you realy want to match vaild E-Mailadresses (rfc822 conformal) you have
to do things like this
--- short pattern start --
(?:[\040\t]|\((?:[^\\\x80-\xff\n\015()]|\\[^\x80-\xff]|\
((?:[^\\\x80-\xff\n
\015()]|\\[^\x80-\xff])*\))*\))*(?:(?:[^(\040)<>@,;:".\\\[\]\000-\037\x80-
Funny,
I just had the same problem!
I converted the blob column to a text column and then the problem went away.
This page may be of use from the MySQL manual:
http://www.mysql.com/doc/en/Case_Sensitivity_Operators.html
But I couldn't get their solution to work, so I changed the format of the
c
hii
im using php with mysql 3.23
in my script im accepting text input and want to compare it with the field
which is of the type blob.
trying with following query.
SELECT * from table where fieldname LIKE '% $textinupt %'
but it is giving case sensitive result bcos the field which im comparin