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

3 votes228 views3 answers
Raw select laravel
SQL
5 votes220 views2 answers
Oracle find all tables with column name
SQL
3 votes216 views2 answers
Monthname sql
SQL
0 vote223 views1 answer
Get who is hired in february in sql
SQL
1 vote205 views2 answers
Sql example query
SQL
1 vote207 views1 answer
Increase existing date in sql oracle
SQL
11 votes218 views2 answers
Having clause in sql
SQL
0 vote197 views1 answer
Show create table in postgresql
SQL
0 vote202 views1 answer
Sql date d'aujourd'hui
SQL
1 vote233 views1 answer
Sql how to replace full stop
SQL