NSString * saveQuery = [[NSString alloc] initWithFormat:@"IF (NOT EXISTS (SELECT * FROM USERDB WHERE email="%@")) BEGIN INSERT INTO USERDB (firstName, lastName, username, email, password) VALUES ("%@", "%@", "%@", "%@", "%@") END ELSE BEGIN UPDATE USERDB (firstName, lastName, username, email, password) VALUES ("%@", "%@", "%@", "%@", "%@") WHERE email = "%@" END", email, firstName, lastName, username, email, password, firstName, lastName, username, email, password, email];
[userDB saveData:saveQuery];