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

0 vote142 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
13 votes136 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
8 votes131 views3 answers
Mysql alter table add index
SQL
0 vote135 views4 answers
Mysql on kubernetes
SQL
-1 vote146 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote92 views1 answer
Get all stored procedures in sql server
SQL
8 votes147 views3 answers
SQL column name
SQL
0 vote140 views1 answer
Postgres in operator with comma separated values
SQL
0 vote147 views1 answer
Sql select random procentage from rows
SQL
1 vote129 views1 answer
Regular expression in sql server
SQL