/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

25 votes220 views1 answer
Mysql grant all privileges to a user
SQL
0 vote221 views1 answer
Mysql_union
SQL
0 vote234 views1 answer
Character count sql
SQL
15 votes232 views3 answers
Find duplicate keys in mysql
SQL
17 votes239 views4 answers
Sort by mysql
SQL
3 votes226 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote200 views1 answer
Mysql get last insert id
SQL
1 vote231 views1 answer
Mysql batch insert
SQL
24 votes216 views5 answers
Sql reset auto increment
SQL
1 vote225 views1 answer
Base nosql
SQL