SELECT
b_option.MODULE_ID AS MODULE_ID,
b_option.NAME AS NAME,
b_option.VALUE AS VALUE
FROM
b_option
WHERE
UPPER(
b_option.NAME
) like upper(
'repletest'
);
INSERT INTO b_option (MODULE_ID, NAME, VALUE)
VALUES ('repletest', 'repletest', '11')
ON DUPLICATE KEY UPDATE VALUE = '11';
SELECT
b_option.MODULE_ID AS MODULE_ID,
b_option.NAME AS NAME,
b_option.VALUE AS VALUE
FROM
b_option
WHERE
UPPER(
b_option.NAME
) like upper(
'repletest'
);
Один if спасет...