MySQL error 1366: Incorrect double value: 'USD 29.42' 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 ("/Sports-Toys/Body-Sport-Neoprene-Dumbbell-Sold-Individually/14095426/product.html?keywords&refinement", "14095426", "https://ak1.ostkcdn.com/img/mxc/flag-logo-fix080123.png", "", "", "", "36520298", "", "USD 29.42", "", "2024-04-25 06:09:24")