Is there any way of limiting the number of charcters that are returned from a query on a MySQL Blob. I wish to do a query (SELECT * FROM table WHERE '%$var%' LIKE blobName😉 and print only the first 250 characters in the blob. Is there a PHP string function, or a MySQL function, or other, that would do this?
You won't be able to do it in your MySQL query directly but you can limit the display.
$var1 = substr($var,0,250);
Will take the sub_string of $var starting at character 0 and going for 250 characters.
That's just what I was after! Thank You! :-)
