/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

9 votes299 views6 answers
Sql add column with default value
SQL
0 vote329 views1 answer
Get clob size oracle
SQL
0 vote297 views1 answer
Sql beginning of previous month
SQL
0 vote303 views1 answer
Cannot start database server xampp mac os
SQL
0 vote308 views1 answer
Sqlalchemy get schema from database
SQL
0 vote321 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote291 views1 answer
Oracle drop default value
SQL
0 vote355 views1 answer
Get substract count sql
SQL
0 vote299 views1 answer
SQL Server Altering Column to be Unique
SQL
1 vote313 views1 answer
Mysql check string don't have number
SQL