Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

RE: [PHP-DB] mySQL 'Like'-Query (BLOB) always case sensitive From: Cal Evans (cal <email protected>)
Date: 01/05/01

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 <email protected>]
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 <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>