/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

2 votes310 views2 answers
Mysqli_real_connect(): The server requested authentication method unknown to the client [caching_sha2_password]
SQL
0 vote271 views1 answer
Sql query with date
SQL
0 vote332 views1 answer
Traccar mysql
SQL
2 votes326 views1 answer
Oracle Column Names of a table
SQL
0 vote275 views1 answer
Oracle sqlp update amount / quantity
SQL
0 vote309 views1 answer
Oracle grant create job
SQL
0 vote297 views1 answer
Delete data from database sqlite android
SQL
1 vote290 views1 answer
How to between in sql
SQL
0 vote285 views1 answer
Sql delete dastabase
SQL
1 vote315 views1 answer
Sql set auto increment back to 0
SQL