Problem building a "or" query

05/05/2019 15:24 devdash#1
i knew that i can build the query using

where XXX = XXX set XXX = XXX

but what if i want to make

where XXX_1 or XXX_2 = XXX set XXX = XXX

with other way, if XXX_1 or XXX_2 = XXX set XXX = XXX

so the query will check the two places i mentioned if one of em got the CONDITION then it set...

i hope u guys understand me, thanks in advance.
05/05/2019 15:33 $WeGs#2
where XXX_1 = XXX and/OR XXX_2 = XXX set XXX = XXX
05/05/2019 15:49 ChaInSaW'#3
UPDATE [tablename]
SET [the_column_to_change] = 'test'
WHERE [first_column_to_check] = 1 OR [second_column_to_check] = 2
05/05/2019 16:33 devdash#4
thanks alot guys, i really appreciate it :)

#TopicClosePlease.