/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 vote206 views1 answer
T sql cursor tr
SQL
0 vote194 views1 answer
Mysql case when null
SQL
0 vote229 views1 answer
Reindex mssql table
SQL
1 vote346 views1 answer
Sql injection
SQL
1 vote235 views1 answer
Sql server loop over query
SQL
0 vote239 views4 answers
Rownum in sql
SQL
1 vote254 views1 answer
Default
SQL
0 vote229 views1 answer
Select all same column value in sql
SQL
0 vote208 views1 answer
Oracle synonym procedure dblink
SQL
0 vote214 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL