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 vote254 views1 answer
Mysql cast null to string
SQL
-1 vote256 views1 answer
Mac mysql workbench console
SQL
0 vote286 views2 answers
How to install psql in ubuntu
SQL
16 votes263 views5 answers
Select last row in sql
SQL
0 vote298 views1 answer
Calculer pourcentage mysql
SQL
0 vote246 views1 answer
Sql fetch next 10 rows pdo
SQL
1 vote193 views1 answer
Convert money to varchar sql server
SQL
7 votes261 views3 answers
Sql fill table with info from anothe rtable
SQL
0 vote256 views1 answer
Dump multiple tables mysql
SQL
0 vote246 views1 answer
Print orcale
SQL