The essence of the problem: in the sql-table there is a field in which the numbers of the form 1,5 lie (a comma stands for the integer and fractional partitions), but the field type is VARCHAR

Question: how is it possible in a specific DB field to be replaced in all records with . one request.

    1 answer 1

    If all the field values ​​are in the same format, then a regular expression is not needed, a simple replacement of substrings is enough. To do this, use the REPLACE function:

     UPDATE somevalue SET somevalue = REPLACE(somevalue, ',', '.')

    Here is the documentation of the function .

    • Yeah, what you need, I could have figured it out myself, but I don’t even know how to google such a question ... - Anatoly Shevelev
    • one
      @AnatolyShevelev is full of English materials. For this question, you can easily find the answer by downloading "mysql update string field" . - AivanF.