/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 vote135 views1 answer
Update one column from another column in same table
SQL
9 votes128 views1 answer
Sql server get utc date
SQL
0 vote138 views1 answer
Min varias colunas spark sql
SQL
0 vote139 views1 answer
Mysql pad zeros
SQL
1 vote127 views1 answer
Postgres get month name from date
SQL
2 votes231 views1 answer
Sql ends with string
SQL
1 vote134 views1 answer
Top 10 rows in mysql
SQL
1 vote119 views1 answer
Sql Split string function
SQL
0 vote134 views1 answer
Conda install pymysql "windows"
SQL
3 votes133 views5 answers
ModuleNotFoundError: No module named 'MySQLdb'
SQL