To replace a question mark with a blank string:

UPDATE node SET title = CONCAT('', TRIM(LEADING '?' FROM title)) WHERE title LIKE '?%';