/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 vote266 views1 answer
Power bi dax add related shows column but not working
SQL
0 vote294 views1 answer
Java nosql sort
SQL
0 vote281 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote298 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
4 votes279 views3 answers
Drop Table Oracle
SQL
1 vote323 views1 answer
Oracle columns table
SQL
0 vote350 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote316 views1 answer
Last 24 HOUR data in mysql
SQL
0 vote277 views1 answer
Call function sql oracle with output put line
SQL
0 vote284 views1 answer
Mysql in clausule string array
SQL