/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

6 votes348 views2 answers
If not exists insert sql
SQL
3 votes361 views1 answer
Postgres add not null to existing column
SQL
1 vote352 views1 answer
Operator does not exist: integer = text
SQL
0 vote340 views1 answer
How to check even or odd in sql
SQL
0 vote337 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote359 views1 answer
Add multiple row table pl sql
SQL
3 votes346 views2 answers
Monthname sql
SQL
4 votes348 views1 answer
Add constraint fk
SQL
5 votes339 views3 answers
Day of week postgresql
SQL
0 vote353 views2 answers
How to set global time_zone in mysql
SQL