Witam,
mam problem ze znalezieniem ceny, ponieważ zawiera znak "€" i z tego, co się orientuję to nie jest to wtedy intiger tylko string, niestety nie wiem jak to zmienić.
// próbowałem tej komendy
SELECT(CONVERT(REPLACE(unit_price,' €',''),UNSIGNED INTEGER)) FROM products;
//zapytanie
select * from products where unit_price > 20.00;
//dane z tabelki
insert into products (products_id, supplier_id, product_type, availability, quantity_in_stock, unit_price) values (1, 2, 'Aerator', true, 7202, '€14,32');
insert into products (products_id, supplier_id, product_type, availability, quantity_in_stock, unit_price) values (2, 7, 'One-Touch Tap', true, 1060, '€15,10');
insert into products (products_id, supplier_id, product_type, availability, quantity_in_stock, unit_price) values (3, 3, 'Shower Water Saver', false, 1797, '€38,21');
insert into products (products_id, supplier_id, product_type, availability, quantity_in_stock, unit_price) values (4, 4, 'Toilet Cistern', false, 1613, '€49,28');
niby wykonuje polecenie ale cena pozostaje bez zmian
02:47:24 SELECT (CONVERT(REPLACE(unit_price,' €',''),UNSIGNED INTEGER)) FROM products LIMIT 0, 50000 4 row(s) returned 0.017 sec / 0.00092 sec
select * from products where unit_price > 20.00;

select * from products;

uzywam MySQL 8.0.26
Bardzo bede wdzieczny za pomoc, dziekuje