Ask MySQL about the problem

Ask MySQL for questions
Want to use SQL instead of PHP code to achieve the following functions: If a record exists to return its ID, if it does not exist, insert and return its ID, can it be implemented? How is it implemented? I hope you have detailed advice

------Solution--------------------
Execute INSERT into table () values () on duplicate key update ...

Then the mysql_insert_id () return is the self-increment ID

But mysql_insert_id's a PHP function.
------Solution--------------------

SQL Code

INSERT IGNORE into table () VALUES ();
