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

10 votes115 views1 answer
Oracle object dependencies
SQL
0 vote112 views1 answer
Sql DATE = GETDATE()
SQL
3 votes128 views2 answers
How to open postgresql in windows
SQL
0 vote124 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote115 views1 answer
Data structures in sql
SQL
0 vote113 views2 answers
Mysql create table if not exists
SQL
0 vote113 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
31 votes123 views4 answers
How to get duplicate records with multiple field in sql
SQL
2 votes116 views3 answers
How to pass password mysql command line
SQL
0 vote120 views1 answer
Left join in codeigniter query builder
SQL