Is it possible to update the substring of a field? I'm trying to do something like this:
UPDATE tblIntervals SET SessionMouseID = 'ggg', substr(SessionID, 0, 3) = 'ggg' WHERE SessionMouseID = 'bbb'
Is it possible to update the substring of a field? I'm trying to do something like this:
UPDATE tblIntervals SET SessionMouseID = 'ggg', substr(SessionID, 0, 3) = 'ggg' WHERE SessionMouseID = 'bbb'