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

8 votes124 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote103 views1 answer
Mysql_num_fields in mysqli
SQL
0 vote117 views1 answer
Sql where part of string match
SQL
0 vote98 views1 answer
Sql min
SQL
1 vote119 views1 answer
Postgresql reset serial counter after deleting content
SQL
0 vote114 views1 answer
Database timezone
SQL
0 vote115 views1 answer
Sql get month from date
SQL
2 votes109 views1 answer
Oracle sql concatenate results into string
SQL
0 vote106 views1 answer
Sql server whoami
SQL
0 vote125 views1 answer
How to get one year old query from plan cache
SQL