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

1 vote247 views1 answer
Create sample data postgresql
SQL
1 vote253 views2 answers
Sql groub by count
SQL
3 votes245 views1 answer
Mysql UPDate with enner join
SQL
0 vote274 views1 answer
FILENAME /usr/bin/mysql does not exists. Make sure correct path is set in /etc/dump admin/settings.conf.
SQL
2 votes251 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
0 vote253 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
4 votes254 views1 answer
Check database name postgresql
SQL
0 vote290 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote281 views1 answer
Sql select sum group by id laravel join
SQL
6 votes281 views1 answer
How to get the size of the database in postgresql
SQL