Mine
public sql v1 · immutableCREATE 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;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;