/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

4 votes202 views1 answer
To date oracle with time
SQL
0 vote218 views1 answer
Fast sql column count
SQL
0 vote217 views1 answer
Space not removing from column in sql
SQL
4 votes219 views1 answer
Id primary key auto generated
SQL
0 vote199 views1 answer
Check index sql server
SQL
0 vote228 views1 answer
How to start my sql server on mac
SQL
4 votes170 views1 answer
Oracle sleep
SQL
4 votes209 views1 answer
What are the data types in sql
SQL
1 vote240 views1 answer
Customer using hdfc bank sql query
SQL
0 vote218 views1 answer
Partitioning in oracle-base
SQL