/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 vote127 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
1 vote130 views1 answer
Oracle list datafiles in tablespace
SQL
0 vote126 views4 answers
Mysql on kubernetes
SQL
0 vote169 views1 answer
How to get table current identity value in sql server
SQL
1 vote113 views4 answers
Sql now
SQL
0 vote126 views1 answer
Acual month sql
SQL
0 vote144 views1 answer
Check database restore status sql script
SQL
0 vote142 views1 answer
Foreign key multiple columns
SQL
0 vote121 views1 answer
Postgresql add not null and not empty constraint
SQL
1 vote160 views2 answers
Laravel jwt generate token
SQL