Getting Error while assigning variable to MySQL database

I am trying to execute the below query and getting the below error. Kindly help me out

datasource = 'MY SQL Server Auth';
conn = database('MYDB','user','pwd');
var= "number";
selectquery = ['Select * from TABLE2 where Sensor_value = ' var];
data = fetch(conn,selectquery)
close(conn)

Error:-

Error using database.odbc.connection/fetch (line 39)

ODBC Driver Error: [MySQL][ODBC 8.0(a) Driver][mysqld-5.7.25-0ubuntu0.18.04.2]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '&' at line 1

Answer 1

[Piyush Kumar]

@Sudharsan K.R,

The issue is with the way the query string is constructed.

var= "number";
selectquery = ['Select * from TABLE2 where Sensor_value = ' var];
disp(selectquery)

    "Select * from TABLE2 where Sensor_value = "    "number"

To fix this, ensure that the variable is correctly concatenated into the SQL query string. In MATLAB, you can use "sprintf" -

selectquery = sprintf('SELECT * FROM TABLE2 WHERE Sensor_value = "%s"', var);
disp(selectquery)

SELECT * FROM TABLE2 WHERE Sensor_value = "number"