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

11 votes734 views4 answers
Reset identity column values in sql server
SQL
0 vote328 views1 answer
Change date format in oracle query
SQL
0 vote275 views1 answer
Mysql database is not starting in xampp
SQL
0 vote315 views3 answers
Drop table operation failed on table 'TableHistory' because it is not supported operation on system-versioned temporal tables.
SQL
-1 vote302 views3 answers
SQL MM/dd/yyyy format
SQL
3 votes296 views2 answers
Brew restart mysql
SQL
0 vote306 views1 answer
How we can perform acid Operations in sql with examples
SQL
1 vote293 views2 answers
T sql get foreign key
SQL
0 vote336 views1 answer
Comparing with today and yesterday record in sql query
SQL
14 votes307 views1 answer
Oracle new column
SQL