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 vote197 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote177 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
3 votes221 views2 answers
Synonym oracle
SQL
0 vote172 views1 answer
Not between mysql
SQL
1 vote153 views2 answers
Mysql SELECT
SQL
22 votes228 views4 answers
Mysql format date
SQL
15 votes179 views2 answers
Select where duplicate mysql
SQL
0 vote180 views1 answer
Unique element in sql
SQL
3 votes161 views3 answers
Mysql select table names
SQL
1 vote163 views1 answer
Mysql return text after a final full stop
SQL