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

7 votes184 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
0 vote230 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote165 views1 answer
Show create table in postgresql
SQL
0 vote169 views1 answer
Check if string is a number sql
SQL
0 vote166 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
9 votes156 views3 answers
Show table columns mysql command line
SQL
0 vote160 views1 answer
Mysql start of today
SQL
14 votes159 views2 answers
How to auto increment in sql
SQL
1 vote277 views1 answer
Mysql monthname
SQL
0 vote159 views2 answers
Show slave status mysql
SQL