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

0 vote211 views1 answer
Trigger vérifier stock
SQL
0 vote212 views1 answer
Increase speed of like queries postgres
SQL
2 votes204 views1 answer
Check isolation level in mysql
SQL
1 vote265 views1 answer
Insert pg result of select
SQL
0 vote228 views1 answer
Oracle chain step succeeded
SQL
0 vote224 views1 answer
How to select an index in oracle sql
SQL
0 vote208 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
1 vote193 views1 answer
Set all the vluses in calumn in sql to false
SQL
94 votes431 views4 answers
Create database postgres
SQL
10 votes191 views3 answers
Sql limit results
SQL