/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 vote344 views1 answer
How to change null display in psql
SQL
1 vote329 views4 answers
Postgres extract date from timestamp
SQL
0 vote325 views1 answer
Sql server remove 0 from left
SQL
0 vote374 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote285 views1 answer
Mysqli or pdo
SQL
0 vote334 views1 answer
Mysql add root password
SQL
4 votes344 views1 answer
Oracle session date format
SQL
1 vote346 views1 answer
Woocommerce mysql price table
SQL
0 vote338 views1 answer
In mysql workbench contnent not feching
SQL
0 vote350 views3 answers
Database restoring error
SQL