/SQL/Mysql query to check record exists in database table or not

Mysql query to check record exists in database table or not

-- 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 vote394 views1 answer
Soql update query
SQL
0 vote367 views1 answer
Select nth row in mysql
SQL
14 votes372 views1 answer
Sql value of string
SQL
4 votes363 views1 answer
Invalid reference to FROM-clause entry for table "unidades
SQL
0 vote349 views1 answer
What is logical database schema
SQL
3 votes390 views1 answer
Sql print all names that start with a given letter
SQL
6 votes361 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote396 views1 answer
Sql server user permissions and roles
SQL
1 vote312 views1 answer
Restart identity postgresql
SQL
0 vote381 views1 answer
Postgresql create table many-to-many
SQL