/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

3 votes123 views1 answer
Sql timestamp to date
SQL
0 vote134 views1 answer
Oracle sql generate list of days
SQL
0 vote150 views1 answer
Oracle chain step succeeded
SQL
49 votes224 views6 answers
Mysql add column to table
SQL
8 votes143 views1 answer
How to check mysql version in xampp
SQL
0 vote101 views2 answers
Https://www.google.com/search?ei=bihqX_v9DJb--gTYoLH4DQ
SQL
-1 vote186 views5 answers
Left join
SQL
1 vote155 views1 answer
Increase date by one day in sql oracle
SQL
0 vote125 views1 answer
Get who is hired in january in sql
SQL
0 vote178 views2 answers
Cascade syntax in sql
SQL