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 vote149 views1 answer
Mysql workbench format date
SQL
0 vote163 views1 answer
EnvironmentError: mysql_config not found
SQL
0 vote135 views1 answer
Output to file mysql
SQL
0 vote155 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote157 views1 answer
Select a row include list of array with join table SQL
SQL
3 votes149 views1 answer
Oracle rollback
SQL
-1 vote139 views1 answer
Extract Data from SQL Server into XML Format
SQL
0 vote154 views1 answer
How to add boolean column in postgresql
SQL
0 vote174 views1 answer
Mysql show create db
SQL
0 vote149 views2 answers
Don't know how to set rpath on your system, if MySQL libraries are not in path mysql2 may not load
SQL