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 vote353 views1 answer
Compression of dabatase mysqldumo
SQL
27 votes382 views5 answers
Mysql set password for user
SQL
0 vote368 views1 answer
Postgres drop type
SQL
2 votes356 views3 answers
Oracle show column of table
SQL
4 votes393 views1 answer
W3schools create table
SQL
5 votes362 views2 answers
Oracle list columns schema
SQL
1 vote412 views1 answer
Oracle see column type
SQL
0 vote299 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote344 views1 answer
Mysql Error Code: 1005
SQL
0 vote383 views5 answers
ABC TO FLEX BATTLE IM POOR
SQL