/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 vote180 views1 answer
Failed to process SQL command - ORA-28014: cannot drop administrative user or role
SQL
5 votes145 views1 answer
Alter table default value mysql
SQL
0 vote171 views1 answer
How to export table data from mysql table in sql format
SQL
10 votes164 views1 answer
Create table oracle
SQL
0 vote334 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote165 views1 answer
Sql constarint
SQL
0 vote194 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL
0 vote174 views1 answer
Use between operator in mysql
SQL
1 vote162 views1 answer
Order by oracle
SQL
1 vote175 views2 answers
Sql left characters
SQL