# Generated SQL Variables

**URL:** <https://community.grafana.com/t/generated-sql-variables/38428>\
**Category:** General\
**Tags:** mysql\
**Created:** [October 26, 2020, 8:36am UTC](https://community.grafana.com/t/generated-sql-variables/38428 "2020-10-26T08:36:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jairdaviscn](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jairdaviscn](https://community.grafana.com/u/jairdaviscn)\
**Post date:** [October 26, 2020, 8:36am UTC](https://community.grafana.com/t/generated-sql-variables/38428/1 "2020-10-26T08:36:24Z")

</div>

![1](https://us1.discourse-cdn.com/grafana/original/2X/b/bee71236913ae898745e4348f9005aebf71e96e5.png) ![2](https://us1.discourse-cdn.com/grafana/original/2X/8/883a3efe737791bce4047e2d03ba7bd2c79f901f.png)

What do you need to do with SQL variables? Help me take a look.

But now~

 ![image](https://us1.discourse-cdn.com/grafana/original/2X/e/e1200a7bf0467bde4f15166f34e3bc704ddae616.png)

---

<div class="post-metadata">

**Author:** ![ivanahuckova](https://sea2.discourse-cdn.com/grafana/user_avatar/community.grafana.com/ivanahuckova/32/8541_2.png) [@ivanahuckova](https://community.grafana.com/u/ivanahuckova)\
**Post date:** [October 26, 2020, 9:25am UTC](https://community.grafana.com/t/generated-sql-variables/38428/2 "2020-10-26T09:25:29Z")

</div>

@jairdaviscn try to use `AND app in (${app:singlequote})`. Basically just remove single quotes that are wrapping template variable.

---

<div class="post-metadata">

**Author:** ![jairdaviscn](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@jairdaviscn](https://community.grafana.com/u/jairdaviscn)\
**Post date:** [October 26, 2020, 9:46am UTC](https://community.grafana.com/t/generated-sql-variables/38428/3 "2020-10-26T09:46:49Z")

</div>

> **[MySQL data source | Grafana documentation](https://grafana.com/docs/grafana/v7.1/features/datasources/mysql/)**
>
> Guide for using MySQL in Grafana

 ![image](https://us1.discourse-cdn.com/grafana/original/2X/a/a543acfcaa73258c9e5e9886c81ebc2ba012abd7.png)

It’s been taken care of. Thank you.