Unsupported Screen Size: The viewport size is too small for the theme to render properly.

delete n ammend data

forums › forums › SQLyog › Using SQLyog › delete n ammend data

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • May 9, 2005 at 8:36 am #17681
      Shadow
      Member

      UPDATE my_table SET my_field=INSERT(my_field, (INSTR(my_field, '-'), 1,'');

      INSERT function will replace '-' character with '' (empty string) at its first occurance(INSTR locates the first occurance) in my_field.

    • May 9, 2005 at 8:38 am #17682
      Shadow
      Member

      If you want to replace more than one occurances of '-' character, then use REPLACE() function insted of INSERT().

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.