Check if record exists mysql

-- 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 vote304 views2 answers
2nd max salary query in sql
SQL
6 votes305 views2 answers
Mysql check auto increment value
SQL
23 votes320 views1 answer
How remove column in mysql
SQL
0 vote313 views1 answer
How to close external sql connection in laravel
SQL
1 vote308 views1 answer
Mysql remove last empty newline
SQL
3 votes286 views1 answer
System.debug apex
SQL
14 votes343 views2 answers
Oracle add attribute to table
SQL
0 vote308 views1 answer
Update using case in mysql
SQL
0 vote320 views1 answer
MySQL import data from large CSV file
SQL
3 votes317 views2 answers
To_char oracle
SQL