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 vote130 views3 answers
Mariadb add foreign key
SQL
0 vote148 views2 answers
Sql trigger difference between for and after
SQL
0 vote154 views1 answer
Postgresql list extensions
SQL
0 vote150 views1 answer
Disable database droping sql
SQL
8 votes160 views4 answers
Postgresql server restart
SQL
1 vote167 views1 answer
Oracle grant select on schema
SQL
5 votes135 views4 answers
Rollback to in sql
SQL
0 vote136 views2 answers
Mysql on update current_timestamp
SQL
6 votes165 views2 answers
Clear a table in mysql
SQL
0 vote150 views2 answers
Return the number of records in a single table mysql
SQL