/SQL/Mysql query to check record exists in database table or not

Mysql query to check record exists in database table or not

-- 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

3 votes151 views1 answer
Force using index plsql
SQL
0 vote145 views1 answer
Laravel eloquent get generated sql
SQL
1 vote174 views1 answer
Epoch time converter in snowflake
SQL
1 vote153 views1 answer
Second last highest id in sql
SQL
1 vote149 views1 answer
Best configuration for display table in sqlplus
SQL
0 vote129 views1 answer
Sql query to select records entered in last 24 hours
SQL
17 votes138 views6 answers
Sql select distinct
SQL
17 votes166 views6 answers
MySQL ORDER BY
SQL
0 vote86 views1 answer
Copy table dbeaver
SQL
1 vote158 views1 answer
Sql server kill all connections
SQL