Advertisement
shakawkaw

Untitled

Apr 7th, 2017
542
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. mysql> select grplist from ringgroups where grpnum='612';
  2. +-------------------------+
  3. | grplist |
  4. +-------------------------+
  5. | 428-438-441-442-443-448 |
  6. +-------------------------+
  7. 1 row in set (0.00 sec)
  8.  
  9. mysql> select extension, name from users where extension in (428,438,441,442,442,448);
  10. +-----------+--------------------------------------------+
  11. | extension | name |
  12. +-----------+--------------------------------------------+
  13. | 438 | 438 GORliniya |
  14. | 441 | Kuznetsova Anna 441 Gorliniya |
  15. | 442 | Vorgunova Anna 442 Gorliniya |
  16. | 428 | Gusevskaya Olesya GORliniya 428 |
  17. | 448 | Beregovets Nataliya 448 Ur otdel Gorliniya |
  18. +-----------+--------------------------------------------+
  19. 5 rows in set (0.00 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement