Search in Google and I did not find an answer for this, it seems easier to ask here.
UPDATE table
SET Paciente = Juan Perez
WHERE RowID IN NOT (1,2.3)
Search in Google and I did not find an answer for this, it seems easier to ask here.
UPDATE table
SET Paciente = Juan Perez
WHERE RowID IN NOT (1,2.3)
In general it means
NO
, in this case thatNO pertenezca a un conjunto
. And in your context is that the RowIDNO
is none of thoseThe operator
IN
allows you to specify multiple values that a column can match. For example:For the opposite, use
NOT IN
, to specify the condition that a column does not have one of the listed values.In the example you posted, all records that don't have an
RowID
equal to 1, 2, or 3 are updated.NOT
goes before theIN
, and that the value of the field should go as text in quotes.