We have saved image in the Mysql database as blob. We want to save these pictures as external file in Jpeg format. Please help us to solve this problem.

Thanks in advance

We have saved image in the Mysql database as blob. We want to save these pictures as external file in Jpeg format. Please help us to solve this problem.

Thanks in advance

If you don't have any preset connection collations ex(utf8_unicode_ci) that preset and stripped all randomized characters from the blob data, it should be simple as extracting the data inside the rows and copy and paste them into a Notepad, and saving the file, and changing the file-extension to .JPEG. It is said many places that storing images this way is risky and very easily corrupted. So it may not work.