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

Using Substr

forums › forums › SQLyog › Using SQLyog › Using Substr

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • August 20, 2004 at 6:59 am #8536
      marcuswong
      Member

      Hi there

      im trying to use

      select substr(id, 0,3)

      from mytable

      to retrieve the numeric part of the string “client33”. Is this feature available in SQLyog?

      I tried to do triggers and its not possible too.. How do i know what functions are supported.

      Thanks

      MArcus

    • August 20, 2004 at 12:45 pm #16195
      CalEvans
      Member

      substring, not substr.

      If sqlyog doesn't color it, it's not a keyword. 🙂

      =C=

    • August 23, 2004 at 8:36 pm #16196
      Shadow
      Member

      No function is supported by SQLyog because it does not have to support any function. It's MySql that executes a function. All that SQLyog can do is to use different color coding for reserved words, function names, etc., to help developers.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.