/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

10 votes219 views4 answers
Else if mysql
SQL
0 vote348 views1 answer
Get first match in each group mysql query
SQL
2 votes218 views1 answer
Mysql shell insert into
SQL
0 vote206 views1 answer
Test database for sql
SQL
0 vote204 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote194 views1 answer
Get duplicate entry sql
SQL
0 vote213 views1 answer
Mariadb current date plus 1 day
SQL
1 vote217 views1 answer
Update foreign key value in mysql
SQL
0 vote234 views1 answer
Sql query inline if
SQL
7 votes192 views3 answers
How to check table name in current database sql
SQL