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

1 vote282 views1 answer
Data type and their numeric form
SQL
1 vote263 views1 answer
Column with prefix in sql
SQL
1 vote292 views1 answer
Date_part mysql
SQL
0 vote310 views1 answer
How to make sure two tables have same exact data in sql
SQL
1 vote289 views1 answer
VERIFY INDEXES IN SQL ORACLE
SQL
0 vote273 views1 answer
Set a default value for a column in sqlite
SQL
4 votes281 views1 answer
Mysql not equal
SQL
0 vote225 views1 answer
Sql count how many times a value appears
SQL
3 votes263 views3 answers
Mysql select table names
SQL
20 votes292 views3 answers
How to open postgresql in mac
SQL