Update table product, set size equal to the number portion of the data in column sizeusing the SUBSTRING_INDEX function, the arguments passed should be column size, an explicit space and the value 1. Example SUBSTRING_INDEX(, ' ', 1).

Please explain the exact syntax needed for the above instruction for SQL.