merge a insert/select statement into one? mysql

Question

Is there a way to make this statement into one? The basic idea is to insert a tag name if it doesnt exist and to retrieve the primary key for my next statement. title column is unique.

INSERT INTO `tag_name` (`count`, `title`) 
SELECT 0, @title FROM DUAL 
WHERE not exists 
    (SELECT * FROM `tag_name` WHERE `title` = @title LIMIT 1);

If rows affect >0 then use last_insert_rowid(), otherwise run this statement

SELECT id from  FROM `tag_name` WHERE `title` = @title

--- here is a test

CREATE TABLE test (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, data int unique);
//insert into test(data) select 5;

Answer 1

you can use the MySql specific Replace syntax. Check here for more information.

Answer 2

you can use

insert into ... on duplicate update

this is insert row and when key was duplicate then update it.also u can use insert into on duplicate update field1=field1 this ignore on duplicate !