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

2 votes148 views1 answer
How to search table name in stored procedure in sql server
SQL
9 votes156 views5 answers
Sql delete duplicate rows but keep one
SQL
1 vote149 views1 answer
Sql pick random row
SQL
0 vote164 views1 answer
Helptext in sql
SQL
3 votes134 views3 answers
Concatenation in sql
SQL
4 votes149 views1 answer
Create table if not exist in sqlite
SQL
1 vote152 views1 answer
Failed to stop mysqld.service: Unit mysqld.service not loaded.
SQL
0 vote151 views1 answer
Postgres sql alter table delete row
SQL
0 vote149 views1 answer
Sql alternative to max statement
SQL
3 votes159 views1 answer
Force using index plsql
SQL