/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 vote166 views1 answer
Look at running processes redshift
SQL
1 vote150 views1 answer
Pv mysql import
SQL
0 vote155 views1 answer
Mariadb errno 121
SQL
0 vote157 views1 answer
Use mysql in java program
SQL
0 vote157 views1 answer
Exit psql
SQL
10 votes239 views2 answers
Doublon sql
SQL
0 vote186 views1 answer
Best sql collation
SQL
0 vote155 views1 answer
Left join in codeigniter query builder
SQL
0 vote118 views1 answer
Sql select rows with simlar names
SQL
2 votes150 views1 answer
Change primary key sql
SQL