/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

22 votes260 views4 answers
Tsql rename table
SQL
1 vote277 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote272 views1 answer
Sql server remove primary key without dropping table
SQL
0 vote267 views1 answer
Product of a column in mysql
SQL
5 votes259 views1 answer
Postgres integer to serial
SQL
7 votes276 views2 answers
Postgres concat
SQL
3 votes304 views2 answers
Synonym oracle
SQL
0 vote253 views1 answer
Truncate a table then insert data
SQL
0 vote280 views1 answer
Sqlalchemy one column of two has to be not null
SQL
1 vote251 views2 answers
Mysql does sentance contain word
SQL