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 vote370 views3 answers
Sql union
SQL
9 votes341 views2 answers
Sql limit order by
SQL
0 vote354 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote383 views1 answer
Carbon mysql d m y to y-m-d
SQL
-1 vote380 views5 answers
Not in sql
SQL
17 votes409 views4 answers
Show all tables in oracle
SQL
0 vote342 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
3 votes324 views1 answer
Mysql UPDate with enner join
SQL
0 vote396 views1 answer
Insufficient privileges while creating view in sql oracle
SQL
4 votes365 views3 answers
Sql drop database if exists
SQL