1. 论坛系统升级为Xenforo，欢迎大家测试！
    Dismiss Notice

数据检索问题.`求教～～

Discussion in '新人报道' started by 小狼, Apr 11, 2006.

  1. 小狼

    小狼 New Member

    Joined:
    Mar 15, 2006
    Messages:
    163
    Likes Received:
    1
    部门 零件型号
    网络部 1_3,2_6,9_5
    生产部 1_0,2_6,7_8
    企化部 1_5,9_5,6_0
    上面是个很简单的数据库中的一个表，
    我想请问，应该怎么样使用where语句，当我查零件型号为２＿６的时候，能将网络部和生产部显示出来，
    当我查零件型号９＿５的时候，能将生产部和 企化部 查找出来．
     
    #1 小狼, Apr 11, 2006
  2. 不学无术

    不学无术 Ulysses 的元神

    Joined:
    Aug 31, 2005
    Messages:
    16,714
    Likes Received:
    39
    WHERE 零件型号 LIKE '%' & strModel & '%'

    strModel 为你要查找的型号。
     
    #2 不学无术, Apr 11, 2006
  3. 小狼

    小狼 New Member

    Joined:
    Mar 15, 2006
    Messages:
    163
    Likes Received:
    1
    谢谢
     
    #3 小狼, Apr 11, 2006
  4. 风狼

    风狼 New Member

    Joined:
    Oct 1, 2005
    Messages:
    7,452
    Likes Received:
    25
    补全
    select * from 表 where 字段名 like '%'&变量名&'%'
     
    #4 风狼, Apr 11, 2006
(You must log in or sign up to post here.)
Toggle Width
Language
English (US)