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

3 votes235 views2 answers
Oracle grants
SQL
1 vote262 views1 answer
Last 24 HOUR data in mysql
SQL
25 votes229 views3 answers
Mysql command show tables
SQL
1 vote245 views1 answer
Sql alchemy with azuresql server
SQL
0 vote236 views1 answer
Enable full text search mysql
SQL
0 vote221 views1 answer
Pl sql turn off variable substitution
SQL
0 vote242 views5 answers
Select concat alter table mysql
SQL
0 vote277 views1 answer
Psql create usr
SQL
2 votes228 views1 answer
Oracle cpu per session
SQL
5 votes246 views1 answer
Mysql last day of next month
SQL