/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 vote77 views1 answer
Count char in java
SQL
2 votes108 views1 answer
Mysql find tables with name
SQL
0 vote119 views1 answer
Postgresql using reserved word as column name
SQL
4 votes171 views1 answer
Oracle change nls_date_format permanently
SQL
-1 vote127 views1 answer
Mysql change database charset and collation
SQL
1 vote115 views1 answer
Oracle create program if no exists
SQL
0 vote118 views1 answer
Microsoft word insert sql code
SQL
2 votes136 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote119 views3 answers
Default password of mysql
SQL
6 votes129 views4 answers
Mysql group by month
SQL