How to display the cheapest among all by condition in SQL?

Question

SQL

For example, there is a price_items table:

id	make_name	cost
one	TOYOTA	350
2	TOYOTA	100
3	FIAT	210
4	TOYOTA	190

There is a condition that you need to pull out TOYOTA where id = 1, but instead of its price it should be the cheapest among such brands, that is, TOYOTA, in fact it is 100.
Request like:

SELECT p2.cost FROM price_items AS p1 INNER JOIN price_items AS p2 ON p1.make_name = p2.make_name WHERE p1.id = 1
ORDER BY p2.cost

, doesn't work because instead of pulling out one row, it pulls out all rows with TOYOTA brands.
How to make the right request?

Answer 1

well, add LIMIT 1 :)

Answer 2

SELECT cost FROM price_items WHERE name = (SELECT name FROM price_items WHERE id = 1)
ORDER BY cost LIMIT 1;

Answer 3

Try like this

$re = '/\bООО\b/u';
$str = 'ООО ОООрогакопат "ООО рогопыт" рОООга "Компания ООО"';

echo preg_replace($re, '', $str);