/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 vote173 views4 answers
Mysql select bottom 10 rows
SQL
0 vote169 views1 answer
Date diff sql
SQL
0 vote163 views1 answer
Sql query to delete row by id
SQL
0 vote173 views1 answer
Postgresql isnull with max
SQL
0 vote166 views1 answer
Oracle job schedules
SQL
0 vote160 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL
5 votes176 views2 answers
Get columns number sql
SQL
0 vote167 views1 answer
Recover deleted data from mysql database
SQL
3 votes158 views1 answer
Pl sql check if variable is empty
SQL
0 vote163 views1 answer
Select max salary from each department in sql
SQL