compare longblob with binary data

[Bernhard Schmidt]

------=_NextPart_000_0099_01C34B87.28543020
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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`=3D?

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`) =3D ? AND `data`=3D?

any suggestions?

best regard
benny
------=_NextPart_000_0099_01C34B87.28543020--