/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

0 vote207 views1 answer
Except in sql alchemy
SQL
58 votes570 views4 answers
Mysql drop column
SQL
-1 vote184 views2 answers
Postgres autoincrement primary key
SQL
2 votes215 views2 answers
SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost' (SQL: select * from information_schema.tables where table_schema = laravel and table_name = migrations and table_type = 'BASE TABLE')
SQL
0 vote176 views1 answer
Limiting query result using where in sql
SQL
0 vote196 views2 answers
How to install mssql on mac
SQL
0 vote276 views1 answer
Run docker container with database as rds metabase
SQL
0 vote184 views1 answer
Create a table from one field of another table
SQL
1 vote191 views1 answer
Random name function in mysql for nvarchar
SQL
65 votes556 views6 answers
Sql add column to table
SQL