If exist Update else insert query

[wasim ahmad]

SELECT IF (EXISTS(
SELECT * FROM Terminal WHERE IP_address=10.40.186.7))
UPDATE terminals SET IP_address=10.40.186.7 WHERE ID=1 and Name='anshu'
ELSE
INSERT INTO Terminal (ID, type_ID, Name,IP_address,tags,create_access_ID,Status_ID)
VALUES (`Id`, `type_ID`,`anshu`,`10.40.192.88`,`Registery`,`a59660306a0e1e`,`0`);


ABOVE QUERY NOT WORKING IN MYSQL 8.0
FOLLOWING ERROR OCCURRED
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.186.7))