Check if record exists mysql

-- 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

3 votes211 views3 answers
Create table in microsoft sql server
SQL
0 vote160 views1 answer
Oracle sql replace string in clob
SQL
0 vote186 views1 answer
How to select only a certain date sql
SQL
5 votes247 views1 answer
How to get all table names in sql query
SQL
8 votes176 views5 answers
Grant permission in postgres
SQL
0 vote180 views1 answer
Longtext sql
SQL
1 vote234 views1 answer
Oracle drop chain step
SQL
0 vote213 views1 answer
Redshift running queries
SQL
5 votes197 views3 answers
Sql max value in column
SQL
9 votes182 views2 answers
Default number in sql
SQL