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

11 votes181 views2 answers
Insert current date sql
SQL
0 vote175 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote179 views1 answer
Mysql count with two joins
SQL
2 votes187 views4 answers
Mysql get all tables row count
SQL
4 votes173 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
3 votes192 views1 answer
Oracle drop user
SQL
1 vote188 views1 answer
Table infromation in sql server
SQL
0 vote176 views1 answer
Sql string contains case sensitive
SQL
-1 vote195 views1 answer
Mysql order by on condition
SQL
1 vote186 views1 answer
Postgresql how to show table names
SQL