Answers for "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;

Posted by: Guest on April-23-2021

Code answers related to "mysql query to check record exists in database table or not"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql query to check record exists in database table or not"

Code answers related to "mysql query to check record exists in database table or not"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "mysql query to check record exists in database table or not"

Code answers related to "mysql query to check record exists in database table or not"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us