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 vote139 views1 answer
Sql server update column based on another table
SQL
0 vote120 views1 answer
Mysql change default collation
SQL
0 vote138 views1 answer
Mysqldump don't drop table
SQL
0 vote120 views1 answer
Sql get date from timestamp
SQL
4 votes125 views1 answer
Force drop all tables postgres
SQL
0 vote144 views1 answer
SQL Server date literal
SQL
0 vote130 views1 answer
Spark sql grows beyond 64 kb
SQL
1 vote190 views1 answer
Mysql stop password policy
SQL
3 votes147 views2 answers
Oracle drop sequence
SQL
13 votes157 views3 answers
List all the tables in sql
SQL