Re: want to compare text input with blob field

thnx for ur reply following query worked fine and served my purpose " SELECT * FROM table where UPPER(blob_field) LIKE '% STRTOUPPER(input_text) %' " thnx and regds, smita.

From: "Milan Reznicek" <reznicekm@gytool.cz> To: "Smita Manohar" <smitamanohar@hotmail.com> Subject: Re: [PHP-DB] want to compare text input with blob field Date: Thu, 22 Aug 2002 10:53:24 +0200 I think MySQL supports some function like LCASE or LOWERCASE so this could work:

    SELECT * FROM table WHERE LCAS(fieldname) LIKE

CONCAT('%',LCASE($textinput),'%') Bye Milan Reznicek Software Developer reznicekm@gytool.cz ----- Original Message ----- From: "Smita Manohar" <smitamanohar@hotmail.com> To: <php-db@lists.php.net> Sent: Thursday, August 22, 2002 10:51 AM Subject: [PHP-DB] want to compare text input with blob field 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

_________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com