/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

1 vote106 views1 answer
Sql sort column by date
SQL
0 vote97 views1 answer
Add plugins to mysql workbench
SQL
4 votes103 views1 answer
Add constraint fk
SQL
0 vote110 views1 answer
Mysql order by rand limit 1 really slow
SQL
11 votes158 views3 answers
Pl sql example
SQL
4 votes97 views1 answer
Mysql set max connections
SQL
1 vote103 views1 answer
Mysql view current queries
SQL
7 votes99 views1 answer
Postgres base size
SQL
0 vote109 views1 answer
Sqlite insert or update
SQL
0 vote113 views1 answer
ACCEPT nome PROMPT on oracle
SQL