help, search in python mysql

[tarata]

If i use no a variable but a value

import time
import MySQLdb
var = 'AAAA'
 
db = MySQLdb.connect(host="localhost", user="root", passwd="", db="db")
 
 
cursor = db.cursor()
 
 
 
sql = "select valore from tab where valore LIKE '%AA%' "
 
number_of_rows = cursor.execute(sql)
 
print(cursor.fetchone())
db.close()

result is ok

('AAAA',)

[tarata]

WINNNNNN

WORK
......

sql = """select valore from tab where valore LIKE '%s' """ % ("%" +var+ "%")
print (%cursor.fetchone())

---

now i have other problem...

my cycle (have  to do cycle one time even if var not change):

var=1


if var != oldvar
oldvar=var
do.....
else

[Larz60+]

Build the test before inserting into the SQL statement like:

qvar = '%{}%'.format(var)
sql = "select valore from tab where valore LIKE qvar"

[tarata]

Build the test before inserting into the SQL statement like:

qvar = '%{}%'.format(var)
sql = "select valore from tab where valore LIKE qvar"

sorry for my bad english i would say;

my cycle have to do if actual var is different from prev var
do it
if var+1 != var
can u help me?

[Larz60+]

if var + 1 = var will always be true

[tarata]

# var is a value for ex temperature of sensor 
# FOR EXAMPLE 
var = '29'

if var != oldvar
oldvar = var
do.....
else

The problem is when first loop of cycle start: if the first temperature is x....
How: oldvar = var ?
HELP..

[Larz60+]

why is your indentation all messed up?
You should cut and paste
If using PyCharm (and perhaps some other IDE's) you may have to use ctrl-shift-v

It looks like you are trying to use oldvar before it has been defined
to start, use:

var = oldvar = '29'

[tarata]

# var is a value for ex temperature of sensor 
# FOR EXAMPLE 
var =  oldvar  = '29'

if var != oldvar
      
       do.....
else

if i write this:

1. first temperature detected is 29
2. assig to oldvar 29
3.cyle never start
i need that cycle start for first time in any case and at th 2nd time  when the 2nd..3...4...5.. etc.. temperature detected is different only from previus

[Larz60+]

You need to start using your noggin.

var =  '29'
oldvar = 0