mySQL 'Like'-Query (BLOB) always case sensitive
| From: | Joachim Maier | Date: | Fri, 05 Jan 2001 14:38:40 +0000 |
| Subject: | mySQL 'Like'-Query (BLOB) always case sensitive | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5621@lists.php.net to get a copy of this message | ||
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