/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

1 vote361 views1 answer
Retrieve meaning
SQL
1 vote354 views2 answers
Mysql remove first and last character from string
SQL
0 vote350 views1 answer
Create query in where clasue
SQL
0 vote355 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
2 votes353 views2 answers
How to check data type in sql server
SQL
1 vote363 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
0 vote368 views1 answer
Search In the Database using Text
SQL
5 votes330 views1 answer
List foreign key oracle
SQL
1 vote359 views1 answer
Launch sql script from docker in mysql
SQL
0 vote372 views1 answer
Clear query cache sql server
SQL