RE: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive

I've not tried it but you might want to try: select myBlob from MyTable where lcase(myBlob) like '%bad%' More info: http://www.mysql.com/documentation/mysql/commented/manual.php?section=String _functions Cal -----Original Message----- From: Joachim Maier [mailto:JMaier@maiersoft.de] Sent: Friday, January 05, 2001 8:39 AM To: ML-PHP-DB Subject: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive Hi all, i'd like to know, whether it's possible to perform a case-INsensitive "like"-query against a mySQL-BLOB field. E.g.: This one IS case-sensitive (myBlob being of BLOB-type): "select myBlob from MyTable where myBlob like '%bad%'" but this one's NOT case-sensitive (myVarChar being of VARCHAR-type): "select myVarChar from MyTable where myVarChar like '%good%'" I do want to build a fulltext-search-engine and cannot use the MATCH-features of the latest mySQL engine. Any ideas? Thanks, Joe -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net