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 vote191 views1 answer
Select mysql limit to 2 decimal places
SQL
10 votes252 views4 answers
SELECT FROM WHERE
SQL
4 votes238 views2 answers
Truncate oracle
SQL
0 vote241 views1 answer
What does leave do in mysql
SQL
0 vote227 views1 answer
Redudancy in SQL
SQL
3 votes176 views1 answer
How to get list of synonyms in oracle
SQL
14 votes219 views1 answer
Excel is not a database
SQL
0 vote225 views2 answers
Csv into data postgres
SQL
2 votes214 views2 answers
Postgres set user as superuser
SQL
1 vote233 views2 answers
Regex starts with
SQL