CREATE PROCEDURE STORE_NEW_URL(IN URL VARCHAR(1000)) BEGIN DECLARE ID BIGINT; SELECT URL_ID INTO ID FROM URL WHERE URL_NAME LIKE '+URL+'; IF ID < 0 THEN INSERT INTO URL (URL_NAME) VALUES (URL); END IF; END;