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 vote190 views1 answer
How to add session data into mysql database from button
SQL
0 vote221 views1 answer
Database db connection string format
SQL
0 vote198 views1 answer
Compare field sql server
SQL
0 vote228 views1 answer
Sql create table with references not primary key
SQL
0 vote199 views1 answer
Default value false mysql
SQL
2 votes190 views2 answers
Postgres trigger insert into another table
SQL
36 votes199 views3 answers
Finding duplicate column values in table with sql
SQL
3 votes181 views2 answers
Current year sql
SQL
-1 vote181 views1 answer
Sql getdate date only
SQL
0 vote190 views1 answer
Alasql delete column
SQL