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 vote238 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
1 vote197 views3 answers
Connection string mysql
SQL
0 vote174 views1 answer
Oracle synonym procedure
SQL
1 vote216 views1 answer
Mysql return text after a final full stop
SQL
3 votes348 views1 answer
Alembic.util.exc.CommandError: Target database is not up to date.
SQL
0 vote247 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote167 views1 answer
Strat with in sql
SQL
8 votes193 views10 answers
Sql
SQL
0 vote176 views1 answer
Update top 100 sql
SQL
16 votes175 views4 answers
Sort by sql
SQL