# View a picture from MySQL table on a project page

**URL:** <https://forum.inductiveautomation.com/t/view-a-picture-from-mysql-table-on-a-project-page/12330>\
**Category:** Archived Topics\
**Created:** [November 7, 2016, 7:42pm UTC](https://forum.inductiveautomation.com/t/view-a-picture-from-mysql-table-on-a-project-page/12330 "2016-11-07T19:42:53Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [November 7, 2016, 7:42pm UTC](https://forum.inductiveautomation.com/t/view-a-picture-from-mysql-table-on-a-project-page/12330/1 "2016-11-07T19:42:53Z")

</div>

I am tapping into a MySql server that stores quality information, it also keeps a picture record of the Reference Image in a MediumBlob type of column.

So in simple terms my query to return a that item that I want to see is:

```auto
SELECT ImageRef FROM productslist WHERE ProductID = 11
```

I don’t see where I can enter a Query for the file in an image viewer. Is there a way to do this??

---

<div class="post-metadata">

**Author:** ![nmudge](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nmudge/32/3394_2.png) [@nmudge](https://forum.inductiveautomation.com/u/nmudge)\
**Post date:** [November 7, 2016, 9:43pm UTC](https://forum.inductiveautomation.com/t/view-a-picture-from-mysql-table-on-a-project-page/12330/2 "2016-11-07T21:43:44Z")

</div>

Hello,

This can be done with a little Python scripting. Check out this post: [inductiveautomation.com/forum/v … age#p59697](https://inductiveautomation.com/forum/viewtopic.php?f=70&t=16322&p=59697&hilit=image#p59697)

Best,