f the
column to TEXT and it works fine.
Cheers
stuart
- Original Message -
From: "Smita Manohar" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 22, 2002 3:51 PM
Subject: [PHP-DB] want to compare text input with blob field
> hii
> im using p
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
