/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

7 votes281 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote268 views1 answer
Sql select merge multiple values
SQL
8 votes294 views3 answers
SQL column name
SQL
2 votes282 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote299 views2 answers
Temp Space
SQL
0 vote276 views1 answer
Distinct data types in a table sql query
SQL
25 votes277 views5 answers
Uninstall mysql ubuntu
SQL
0 vote277 views1 answer
Hex string sql becomes int64
SQL
0 vote275 views1 answer
Create table with float datatype in sql server
SQL
4 votes280 views1 answer
Datepart postgres
SQL