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

User Variables

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › User Variables

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • March 24, 2005 at 6:05 pm #8870
      jtinsky
      Member

      set @list := '';

      select @list := CONCAT(@list, STAFF_ID, ',') from STAFF_PROFILES WHERE LEFT(LAST_NAME, 1) = 'a';

      SET @list = IF(LENGTH(@list)=0,'',LEFT(@list,LENGTH(@list)-1));

      select USERNAME from STAFF where FIND_IN_SET(STAFF_ID, @list) > 0

      only returns:

      1,

      1,2,

      1,2,154,

      1,2,154,123,

      instead of the staff usernames like it does in the MySQL console or in PHP MyAdmin

    • March 24, 2005 at 10:25 pm #17226
      CalEvans
      Member

      err…umm…check the '2 Reults' tab in the results pane. It worked for me. (different table and field names, of-course)

      =C=

    • March 24, 2005 at 10:30 pm #17227
      jtinsky
      Member

      OK, now I feel really dumb. Thanks!

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