› 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 · 2930 views
    This topic created in 4033 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   ·   Privacy   ·   Solana   ·   891 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 19:33 · PVG 03:33 · LAX 12:33 · JFK 15:33
    ♥ Do have faith in what you're doing.