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 vote295 views1 answer
Ora 00001 error catch plsql
SQL
3 votes323 views1 answer
Mysql insert on dupèlicate
SQL
4 votes317 views1 answer
Find tables with column name in sql
SQL
0 vote311 views1 answer
R2dbc-postgresqldriver dependency
SQL
0 vote309 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote302 views1 answer
Mysql disable query caching
SQL
0 vote332 views1 answer
Sql select column name like from multiple tables
SQL
0 vote292 views1 answer
We are intrested to work with your organization
SQL
19 votes302 views2 answers
Mysql add column after another
SQL
0 vote300 views1 answer
Which MySQL data type to use for storing boolean values
SQL