/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 vote185 views1 answer
How to select all fieldsin a soql query
SQL
-2 votes179 views3 answers
Oracle tablespace usage
SQL
0 vote159 views4 answers
Sql limit 1 offset 1
SQL
-1 vote183 views3 answers
Error mysql shutdown unexpectedly
SQL
0 vote200 views2 answers
Sql having multiple conditions
SQL
0 vote183 views1 answer
Sql counter column
SQL
1 vote177 views1 answer
Show per page table in xampp
SQL
1 vote180 views1 answer
Login to database mysql terminal
SQL
1 vote182 views1 answer
Copy postgres table from one schema into another
SQL
5 votes173 views2 answers
Copy data from one database to another
SQL