hi all a question about checking the data of a longblob for equality. assume the `data` field is of type longblob. the following statement returns the image records with equal data.
SELECT * FROM `image` WHERE `data`=? how does mysql performe the test. does it check the length of the blob before comparing the data, or makes it sense to add the length test as follows SELECT * FROM `image` WHERE LENGTH(`data`) = ? AND `data`=? any suggestions? best regard benny
