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;

Similar codes

1 vote324 views1 answer
CREATE DATABASE db; SyntaxError: Unexpected identifier
SQL
0 vote347 views1 answer
Select place default lat long
SQL
4 votes325 views1 answer
Add constraint fk
SQL
5 votes329 views1 answer
Sqlite alter table add column
SQL
0 vote325 views1 answer
Sql bild in function
SQL
6 votes332 views2 answers
Drop foreign key
SQL
0 vote322 views1 answer
Mysql docker image arjun
SQL
0 vote338 views1 answer
Oracle drop type
SQL
0 vote451 views5 answers
Right join
SQL
1 vote334 views1 answer
Load mysql dumb
SQL