Not equal where condition on index as a performance problem

Code

-- tested with MySQL 5.6

EXPLAIN SELECT name, status, price FROM history
  WHERE name = 'foo';

EXPLAIN SELECT name, status, price FROM history
  WHERE name != 'foo';

Result

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	ref	name_timestamp_idx,name_status_idx	name_timestamp_idx	767	const	201	100	null

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	history	null	ALL	name_timestamp_idx,name_status_idx	null	null	null	1407	85.71	Using where

More Snippets

Instead of MySQL's IFNULL function, this works on PostgreSQL, Sqlite and others too
Combined indexes may not work with OR. Try an index_merge in MySQL
Even LIKE can use an index in SQL. It depends on the wildcard.

Used Versions

PHP 8.2, Laminas MVC 3.2, Symfony 5.2, Laravel 8.28, PHPUnit 9.5, Doctrine ORM 2.8