/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 vote323 views1 answer
Sql truncate table referencing itself
SQL
0 vote322 views1 answer
Mysql earlier than date
SQL
1 vote391 views1 answer
Backup mysql schema only
SQL
0 vote375 views1 answer
Search In the Database using Text
SQL
1 vote365 views1 answer
Mysql data from file
SQL
0 vote387 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote320 views1 answer
Get only first row mysql
SQL
3 votes419 views5 answers
No module named 'MySQLdb'
SQL
0 vote359 views1 answer
Mysql change timestamp on update
SQL
3 votes412 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL