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 comparing with text input is blob. what should i do to avoid case sensitive result??? is it required to convert input text also in boob format?? then how to do that?? thnx and regds, smita. _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php