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

-1 vote121 views2 answers
Postgres autoincrement primary key
SQL
0 vote135 views1 answer
Postgresql auto increment not working
SQL
0 vote127 views1 answer
How to check the port of mysql installation in mac
SQL
0 vote140 views1 answer
Sql decimal to 2 places
SQL
0 vote143 views1 answer
Check command
SQL
6 votes111 views4 answers
Eloquent to sql with bindings
SQL
0 vote127 views1 answer
Sql offfset
SQL
0 vote124 views1 answer
Low level operator in dbms
SQL
2 votes138 views2 answers
Mysql on duplicate key update get value from values
SQL
0 vote78 views1 answer
Microsoft sql server management studio clear cache
SQL