mysql check record exists before insert code example
Example: check if record exists mysql
-- Returns 1 if exists, 0 else
SELECT EXISTS(SELECT 1 FROM my_table WHERE text LIKE '%something%');
SELECT
CASE
WHEN EXISTS(SELECT 1 FROM my_table WHERE text LIKE '%something%') = 1 THEN
'It exists'
ELSE 'Does not exist'
END;