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 vote132 views2 answers
Mysql trim whitespace
SQL
9 votes157 views2 answers
Oracle all tables in schema
SQL
14 votes144 views2 answers
Sql cast
SQL
0 vote155 views1 answer
Test database for sql
SQL
1 vote160 views2 answers
Mysql switch case
SQL
5 votes129 views1 answer
Ora-00054 find lock
SQL
1 vote145 views1 answer
Operator does not exist: integer = text
SQL
3 votes171 views4 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client vs code
SQL
8 votes136 views1 answer
Today minus 15 days postgresql
SQL
1 vote148 views1 answer
Oracle apex run 404
SQL