/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 vote232 views1 answer
Sqlite3 not commit
SQL
0 vote259 views1 answer
Sql server roles and users
SQL
3 votes278 views2 answers
Order by postgresql
SQL
0 vote276 views2 answers
Call to undefined function mysql_query()
SQL
0 vote288 views2 answers
Clauses in mysql
SQL
0 vote259 views1 answer
Qt qsql check if table exist
SQL
0 vote281 views1 answer
What logs are available on RDS MySQL?
SQL
0 vote285 views1 answer
Python sql passer des parametres dans une requet pymysql
SQL
0 vote252 views1 answer
Update using case in mysql
SQL
0 vote220 views1 answer
Mysql timeout 30 seconds
SQL