Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
UPDATE `#__users` as a
INNER JOIN (
SELECT * FROM `#__users`
WHERE `username` > 1
ORDER BY `username` DESC
LIMIT 1
) AS b
ON a.`id` = '[user_id]'
AND b.`username` > 1
SET a.`username` = b.`username` + 1;
Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.