/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

0 vote177 views1 answer
Sql doesn't contain
SQL
2 votes254 views2 answers
Set value to null sql
SQL
0 vote188 views1 answer
Split first name and last name in sql
SQL
3 votes161 views1 answer
Oracle rollback
SQL
0 vote164 views1 answer
Copy Table from SQL to CSV
SQL
1 vote171 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote191 views1 answer
Sql query use select name inside where clause
SQL
0 vote206 views1 answer
Sql from null to not null
SQL
23 votes173 views1 answer
How remove column in mysql
SQL
0 vote162 views1 answer
Get number of table colums in sql query
SQL