/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 vote284 views1 answer
Trigger stock phpmyadmin
SQL
0 vote265 views1 answer
Run mssql server terminal
SQL
1 vote260 views1 answer
Get the User Name and Domain Name from an Email Address
SQL
1 vote250 views1 answer
Sql injection
SQL
0 vote259 views1 answer
Sql case when exists in another table
SQL
0 vote294 views1 answer
Oracle session statistics
SQL
1 vote276 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
8 votes266 views1 answer
Alter tablespace add datafile autoextend
SQL
-2 votes258 views3 answers
Oracle tablespace usage
SQL
0 vote281 views1 answer
How to find table lock and row lock in mysql
SQL