/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 votes176 views1 answer
Adding data to table in sql python
SQL
15 votes178 views4 answers
How to get all tables in sql
SQL
0 vote188 views1 answer
Insert output identity
SQL
18 votes186 views4 answers
Uninstall mysql on ubuntu
SQL
3 votes159 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
0 vote134 views1 answer
Java spring boot connect to sql server
SQL
9 votes209 views3 answers
Postgres make sql dump
SQL
1 vote199 views1 answer
Sql order by where condition
SQL
0 vote175 views1 answer
Oracle right characters
SQL
0 vote194 views1 answer
Groupby sort sql hive
SQL