/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 vote127 views1 answer
R write csv without index
SQL
0 vote138 views1 answer
T-SQL Create Trigger
SQL
0 vote118 views3 answers
Average salary in sql
SQL
17 votes119 views4 answers
Show tables sql server
SQL
0 vote116 views1 answer
How to print out column name differently in mysql
SQL
13 votes121 views5 answers
Oracle list tables
SQL
0 vote123 views1 answer
What is metadata in sql
SQL
0 vote126 views2 answers
Auto increment column in mysql query results
SQL
0 vote147 views2 answers
Insert data mysql with cmd
SQL
0 vote116 views1 answer
Update having mysql
SQL