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 vote202 views1 answer
Sum sqlserver
SQL
6 votes200 views1 answer
Oracle rank() over (partition)
SQL
0 vote226 views1 answer
Create table sql generator
SQL
16 votes231 views1 answer
Mysql reset auto increment value
SQL
0 vote233 views1 answer
C# get sql min date
SQL
1 vote223 views1 answer
Postgresql float 2 decimal places
SQL
3 votes225 views2 answers
Brew restart mysql
SQL
0 vote203 views1 answer
Create domain sql
SQL
1 vote222 views2 answers
How to check if sql query is correct online
SQL
0 vote236 views1 answer
Ms sql print more than 1 variable
SQL