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 vote101 views2 answers
Get all index postgres
SQL
20 votes109 views1 answer
Sql change column types
SQL
-1 vote144 views1 answer
Minus vs except in sql
SQL
3 votes112 views3 answers
Raw select laravel
SQL
15 votes113 views5 answers
Select all tables sql
SQL
15 votes107 views2 answers
Open postgress in terminal mac
SQL
1 vote325 views1 answer
How to make a select in sql
SQL
0 vote108 views1 answer
How to use sqlcommand
SQL
0 vote155 views1 answer
Scheduled mysql database backup in linux
SQL
2 votes96 views1 answer
Create table with primary key
SQL