[Gammix]

pawn Код:

new query[150];

strcat(query, "UPDATE `user_table` SET `name` = '");
strcat(query, new_name);
strcat(query, "' WHERE `name` = '");
strcat(query, old_name);
strcat(query, "'");

// run a query

Naming is self explanatory, plus learn SQL from here maybe: http://www.tutorialspoint.com