/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

31 votes344 views2 answers
Grant all priviledges to mysql user
SQL
0 vote342 views1 answer
Sql query contains multiple ids
SQL
3 votes316 views2 answers
Funktion LOWER/UPPER sql
SQL
1 vote329 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote331 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
1 vote302 views1 answer
Select not matching data from two tables
SQL
2 votes331 views1 answer
Sqlite insert if not exists
SQL
0 vote327 views1 answer
Join in update query in mysql
SQL
0 vote311 views1 answer
Implicit inner join table alias with id values
SQL
0 vote331 views1 answer
Python mysql query to dataframe
SQL