/SQL/Mysql query to check record exists in database table or not

Mysql query to check record exists in database table or not

-- 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 vote305 views1 answer
Postgresql alter column nullable
SQL
1 vote317 views1 answer
Moodle query item quiz
SQL
0 vote340 views2 answers
Execute stored procedure without db set
SQL
0 vote330 views1 answer
Mysql multiple group by
SQL
2 votes327 views2 answers
Mysql alter column default
SQL
3 votes278 views1 answer
How to get list of synonyms in oracle
SQL
5 votes325 views1 answer
Get table columns from sql
SQL
0 vote358 views1 answer
Mysql create index lost connection
SQL
14 votes333 views3 answers
Inner join sql oracle
SQL
0 vote331 views1 answer
Coalesce for comma separated in sql server
SQL