MySQL error 1366: Incorrect double value: 'USD 121.91' for column 'price' at row 1
When executing:
REPLACE INTO `overstock.com` (`uri`, `prod_id`, `image`, `title`, `brand`, `mpn`, `sku`, `upc`, `price`, `download_status`, `downloaded_at`) VALUES ("/Home-Garden/Lithonia-Lighting-LTH9000-PAR38-WH-M12-White-5.5-inch-x-9-5-8-inch-Front-loading-1-2-Circuit-PAR38-compatible-Track-Head/12862780/product.html", "12862780", "https://ak1.ostkcdn.com/img/mxc/flag-logo-fix080123.png", "", "", "", "19624761", "", "USD 121.91", "", "2024-06-01 01:13:29")