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 vote136 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote130 views1 answer
Oracle select invalid views
SQL
0 vote130 views1 answer
Sql server list user permissions
SQL
0 vote132 views1 answer
Codeigniter MySQL - Issue with SELECT & GROUP BY
SQL
5 votes145 views2 answers
Oracle rename table
SQL
7 votes161 views3 answers
Sql server check if temp table exists
SQL
5 votes131 views2 answers
Get number of columns sql
SQL
0 vote136 views1 answer
Create domain sql
SQL
0 vote133 views1 answer
Select amount weeks between two dates mysql
SQL
150 votes316 views10 answers
Grepper
SQL