I have a variable named “name”. When I use $name in the mysql query (to construct graphs) i can obtain the string “AAAVVV”, but i hope i can get the string “AAA”,is there anyway to achieve the function ?

Are you saying that you have a Grafana variable named “name” and whose value is “AAAVVV”, or that you have a Grafana variable named “name”, which, when you include it in a MySQL query, returns the MySQL value “AAAVVV”? Also, you say that you can obtain the string “AAAVVV” but you hope to get the …

I have a variable $name, the value format of the variable is AAAVVV, CCCDDD etc. in mysql query I need to use part of $name (Example: AAA) but not the whole of it.

I think this topic is closed :slight_smile: solution is below [image] Trying to understand variables I have found a solution. I used views in mysql.

Use part of the variable in mysql query?

General

deejayluk October 12, 2020, 4:56am 4

I think this topic is closed
solution is below

Topic		Replies	Views
Trying to understand variables General	19	2254	October 12, 2020
Mysql variable head explosion MySQL dashboard-variables	0	528	February 20, 2023
Grafana MySQL Query Variable MySQL templating , mysql	2	12979	April 12, 2018
Generated SQL Variables General mysql	2	498	October 26, 2020
Use Part of Variable as Input to An SQL Query Dashboards	5	339	September 4, 2024

Use part of the variable in mysql query?

Related topics