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

5 votes312 views1 answer
Oracle ora-00054 causes
SQL
0 vote292 views3 answers
Mysql calculate age from date of birth
SQL
0 vote328 views1 answer
Oracle sql procedure return value
SQL
0 vote318 views1 answer
Difference between varchar and varchar2
SQL
1 vote361 views1 answer
Insert many to many sql
SQL
1 vote340 views1 answer
Mysql show database size in mb
SQL
20 votes344 views1 answer
Sql change column types
SQL
0 vote353 views1 answer
Possgress drop if exists view
SQL
15 votes334 views4 answers
How to get all tables in sql
SQL
1 vote363 views1 answer
Sqlalchemy on delete set null
SQL