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

2 votes62 views2 answers
Mysql get last character of string
SQL
1 vote95 views3 answers
Java.sql.sqlexception: access denied for user
SQL
4 votes106 views3 answers
Postgres set default value
SQL
0 vote102 views1 answer
Mysql show category once count how many products
SQL
0 vote60 views1 answer
Sql query with date
SQL
0 vote112 views1 answer
Plpgsql raise notice
SQL
-3 votes100 views1 answer
Remove spaces sql 2008
SQL
1 vote112 views1 answer
Sql server locks
SQL
17 votes109 views6 answers
Change column name in sql
SQL
1 vote120 views1 answer
Postgresql delete cascade
SQL