/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 vote293 views1 answer
Mysql 5.6 hierarchical recursive query
SQL
0 vote271 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
4 votes298 views2 answers
Sql offset
SQL
1 vote309 views3 answers
Epoch to datetime
SQL
1 vote296 views1 answer
SQL Integer devision
SQL
3 votes269 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
2 votes313 views1 answer
Oracle block
SQL
11 votes306 views6 answers
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
SQL
1 vote295 views2 answers
Sql for date greater than
SQL
2 votes301 views2 answers
Storing timezones in postgres
SQL