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

50 votes254 views6 answers
Sql duplicate rows
SQL
5 votes177 views1 answer
Invalid column name sql
SQL
0 vote200 views2 answers
Athena drop partition
SQL
0 vote287 views1 answer
SQL query to verify the size of the table
SQL
58 votes560 views4 answers
Mysql drop column
SQL
-1 vote242 views1 answer
Install mysql 5.7 ubuntu 20.04
SQL
0 vote191 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL
1 vote181 views2 answers
Mysql filter by date mount
SQL
0 vote178 views1 answer
Tsql delete all rows
SQL
2 votes195 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL