/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

4 votes209 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
5 votes194 views1 answer
Add column table sql default value
SQL
0 vote167 views1 answer
Importerror no module named mysql.connector raspberry pi
SQL
-1 vote165 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote172 views1 answer
Plpgsql coalesce equivalent for empty string
SQL
0 vote176 views1 answer
Alter table myisam to innodb
SQL
0 vote180 views1 answer
SAP Return
SQL
6 votes309 views1 answer
Sql insert values into table
SQL
0 vote183 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote242 views1 answer
Create table with timestamp mysql youtube
SQL