/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 vote113 views2 answers
Mysql password error create datbase
SQL
5 votes120 views2 answers
Ranking functions in sql
SQL
0 vote129 views1 answer
Sqlite update where exists
SQL
0 vote115 views1 answer
Timestamp(0) postgresql
SQL
0 vote121 views1 answer
Dataframe lambda elif
SQL
2 votes112 views1 answer
Mysql add boolean column
SQL
0 vote123 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote138 views1 answer
Cube oracle
SQL
1 vote80 views1 answer
Postgresql last element of array
SQL
2 votes144 views1 answer
Find column in all stored procedures sql server
SQL