Im trying to save the result of IF in a specific row

SELECT *, IF(tecno!='5G',left(site,3),left(site,8)) AS result FROM table);