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 vote384 views1 answer
Nuget sqllite-net-pcl
SQL
6 votes387 views2 answers
Insert into select mysql
SQL
4 votes333 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote346 views2 answers
Sql 2 way of select unique
SQL
1 vote349 views1 answer
PLS-00225 type
SQL
0 vote350 views1 answer
No suitable driver found for sqlite
SQL
0 vote371 views1 answer
Shows all databases created by user in ms sql
SQL
23 votes358 views1 answer
How remove column in mysql
SQL
5 votes397 views2 answers
How to ascending order in sql
SQL
0 vote388 views1 answer
Order child below the parent in mysqli
SQL