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 vote345 views1 answer
Test database for sql
SQL
23 votes342 views3 answers
Mysqldump
SQL
0 vote350 views3 answers
Duplicate row mysql
SQL
0 vote321 views1 answer
How to find unique key in sql
SQL
0 vote321 views1 answer
Select password from user mysql
SQL
0 vote345 views2 answers
Android sqlite query join
SQL
0 vote321 views1 answer
On update current_timestamp jpa
SQL
1 vote343 views1 answer
Postgres get month name from date
SQL
0 vote317 views1 answer
Sql select rows between 1000 and 2000
SQL
7 votes321 views2 answers
Get database size mysql
SQL