/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 vote337 views1 answer
Psql connections
SQL
0 vote333 views1 answer
Sql select lowest value row
SQL
2 votes347 views1 answer
Sql server check for value in multiple columns
SQL
0 vote337 views1 answer
Full outer join in mariadb mysql
SQL
26 votes322 views6 answers
Modify column name in sql
SQL
1 vote337 views1 answer
Where date = max(date) in sql
SQL
3 votes305 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
4 votes318 views1 answer
Oracle select first 10 rows
SQL
10 votes327 views3 answers
How to fetch first 5 characters in sql
SQL
0 vote337 views1 answer
Top frequency in sql server
SQL