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 vote273 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
12 votes287 views6 answers
Select distinct
SQL
-1 vote275 views3 answers
Mysql get age from date
SQL
2 votes276 views2 answers
Install sqlalchemy
SQL
5 votes282 views2 answers
Oracle timestamp to date
SQL
3 votes265 views1 answer
What is having clause
SQL
1 vote319 views1 answer
Floor function in sql oracle
SQL
0 vote369 views1 answer
What is common table expression in sql
SQL
0 vote351 views1 answer
Sqlite schema structure of a relational database
SQL
3 votes329 views2 answers
Wp do sql query from function
SQL