<div>
first part * 256 + second part does the job.<br />
Strange that there is no working cast for this... (not that I know) ?<br />
<br />
Thanks for the solution leannonn !<br />

</div>


first part * 256 + second part does the job.
Strange that there is no working cast for this... (not that I know) ?

Thanks for the solution leannonn !


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a BLOB field and i want to take 2 bytes from it and use them as an integer. &nbsp;How can i do this? &nbsp;<br />
<br />
EG:<br />
select substr(blobfield,195,2) as value1 from mytable;<br />
<br />
the 2 bytes on position 195 and 196 are an integer that was stored inside a blob field.<br />
<br />
How can i get the integer back in mysql, so i can perform a where / having on this value ?<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>
</div>


Hi,

I have a BLOB field and i want to take 2 bytes from it and use them as an integer.  How can i do this?  

EG:
select substr(blobfield,195,2) as value1 from mytable;

the 2 bytes on position 195 and 196 are an integer that was stored inside a blob field.

How can i get the integer back in mysql, so i can perform a where / having on this value ?








mysql: convert 2 bytes from blob to integer

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.