/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 vote207 views1 answer
Mysql date equals to current_date plus days
SQL
0 vote152 views1 answer
How to see the content of tables in pgadmin
SQL
0 vote192 views1 answer
Mysql could not fetch tables
SQL
5 votes203 views4 answers
Upload database mysql command line
SQL
0 vote199 views1 answer
Mysqlcli how to load external sql file
SQL
0 vote192 views1 answer
Mysql search multiple tables
SQL
0 vote205 views1 answer
For row in sql database python loop
SQL
0 vote188 views1 answer
Check if record exists mysql
SQL
0 vote204 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote234 views1 answer
How to get table id sequence postgres
SQL