Search for value within BLOB column in MySQL
If you want to make it work for both uppercase, lowercase or mixed... Make the search string in lower case before applying in mysql query and use LOWER() mysql function in query. make sure to escape string for mysql.
$search_text = strtolower($search_text);$query = 'SELECT * FROM tablename WHERE LOWER( blob_field_name ) LIKE "%$search_text%"';