MySQL 5.5 Community Server
MySQL 5.6 Community Server
Percona Configuration Wizard
XtraBackup 搭建主从复制
Great Sites on MySQL
Percona
MySQL Performance Blog
Severalnines
推荐管理工具
Sequel Pro
phpMyAdmin
推荐书目
MySQL Cookbook
MySQL 相关项目
MariaDB
Drizzle
参考文档
http://mysql-python.sourceforge.net/MySQLdb.html
north521
V2EX  ›  MySQL

客户组 group_id, 5,7 等,数据库存在几条项目,有个字段 group_id,‘5,7,9’代表有权限的组,能否直接用 sql 语句判断 用户的 group_id 是否匹配

  •  
  •   north521 · Sep 11, 2015 · 2711 views
    This topic created in 3917 days ago, the information mentioned may be changed or developed.

    name group_id
    jack 5
    mack 7
    sun 9

    project group_id
    AA 7,8
    BB 78,9

    如果用 like
    则 7 会同事匹配出 7 78
    但我只要 7,8 这条看到

    2 replies    2015-09-11 11:10:06 +08:00
    patosky
        1
    patosky  
       Sep 11, 2015   ❤️ 1
    find_in_set?
    north521
        2
    north521  
    OP
       Sep 11, 2015
    @patosky 谢谢,解决
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1724 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 28ms · UTC 16:27 · PVG 00:27 · LAX 09:27 · JFK 12:27
    ♥ Do have faith in what you're doing.