MySQL error 1366: Incorrect double value: 'MXN 561.67' 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 ("/Clothing-Shoes/Amanda-Chelsea-NEW-White-Womens-Size-14X27-Capris-Cropped-Pants/15088235/product.html", "15088235", "https://ak1.ostkcdn.com/img/mxc/flag-logo-fix060120.png", "", "", "", "21576982", "", "MXN 561.67", "", "2024-06-03 06:20:14")