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 vote195 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
1 vote204 views1 answer
Pl sql ptint
SQL
7 votes195 views1 answer
Mysql iif
SQL
0 vote209 views2 answers
CREATE OR REPLACE FUNCTION
SQL
44 votes207 views6 answers
Rename command in sql
SQL
1 vote226 views1 answer
Insert many to many sql
SQL
1 vote180 views1 answer
Sql get all columns from one table but one from another inner join
SQL
4 votes197 views2 answers
Convert utc to est sql
SQL
4 votes196 views1 answer
Find tables with column name in sql
SQL
4 votes196 views1 answer
Mysql query first character
SQL