/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 vote110 views1 answer
Adding primery key constraint to a column
SQL
3 votes109 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL
0 vote137 views1 answer
Postgres docs /copy metacomand
SQL
4 votes112 views1 answer
Mac install mysql
SQL
0 vote104 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote133 views1 answer
Sql_inner_join
SQL
1 vote173 views1 answer
Truncate table in postgresql and reset id
SQL
2 votes110 views3 answers
Replace null in sql
SQL
23 votes115 views4 answers
How to uninstall postgresql in ubuntu
SQL
2 votes152 views1 answer
Remove foreign key constraints in postgres
SQL