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 vote212 views1 answer
Mysql select count if contains
SQL
0 vote301 views1 answer
Mysql grant access to one database
SQL
1 vote238 views1 answer
Mysql select update same table
SQL
0 vote180 views1 answer
Error code 1241 mysql
SQL
0 vote262 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote220 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote198 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote195 views1 answer
How to check which sp is running in sql server
SQL
0 vote212 views1 answer
Sql server phone constraint
SQL
0 vote199 views2 answers
How to count codition
SQL