/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

10 votes335 views5 answers
Create table mysql query
SQL
3 votes298 views1 answer
Postgres update column with value from another table
SQL
2 votes318 views2 answers
Calculate percentage in sql
SQL
2 votes300 views1 answer
Sql column values comma separated
SQL
2 votes315 views3 answers
Postgres create view
SQL
0 vote285 views2 answers
Sqlite
SQL
16 votes370 views3 answers
Get count of duplicate records
SQL
1 vote289 views1 answer
Nested if in mysql
SQL
1 vote327 views1 answer
Oracle get current schema
SQL
62 votes420 views8 answers
Mysql add column
SQL