/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

2 votes241 views3 answers
Mysql list tables by size
SQL
7 votes241 views1 answer
Sql server convert string to date
SQL
0 vote251 views1 answer
Python connect to mysql in settings.py
SQL
9 votes254 views4 answers
How to alter table column name in mysql
SQL
16 votes257 views3 answers
Get count of duplicate records
SQL
0 vote238 views1 answer
Google sheets data validation custom formula filter
SQL
2 votes233 views2 answers
Get all tables using like
SQL
5 votes247 views5 answers
Sqlite install python
SQL
0 vote227 views1 answer
Alter precision
SQL
0 vote230 views1 answer
Add column not null with default value postgres
SQL