/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

15 votes210 views5 answers
Select all tables sql
SQL
0 vote224 views1 answer
Sql query to select even numbers
SQL
0 vote193 views1 answer
Select distinct after join
SQL
0 vote207 views1 answer
How to see the query of a view in mysql
SQL
0 vote193 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote199 views1 answer
Update top 100 order by sql server
SQL
0 vote176 views1 answer
Sql server select furst day of current year
SQL
1 vote197 views1 answer
Show indices in mysql table
SQL
11 votes189 views2 answers
Having in sql
SQL
0 vote176 views1 answer
Join creating duplicate columns sqllite
SQL