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 vote145 views1 answer
How to connect pgadmin with excel
SQL
7 votes155 views2 answers
Create index mysql
SQL
1 vote172 views1 answer
Psql connect to another database
SQL
0 vote176 views1 answer
Command to give readonly access to a postgres sql user
SQL
4 votes165 views2 answers
Mysql delete user if exists
SQL
0 vote251 views1 answer
Run mysql xampp shell
SQL
4 votes150 views1 answer
Datepart postgres
SQL
0 vote157 views1 answer
Mysql create pool
SQL
0 vote163 views4 answers
Change schema in sql server
SQL
3 votes187 views2 answers
Find string in stored procedure sql server
SQL