Waterchestnut
V2EX  ›  问与答

MYSQL 问题请教~

  •  
  •   Waterchestnut · Jan 21, 2020 · 3308 views
    This topic created in 2482 days ago, the information mentioned may be changed or developed.

    现在有个业务代码里有 like “XXX_%” 前缀匹配。但是 _ 这个符号会被认为是通配符,其实我想将它当作字符串匹配。百度了下,没有搜到我想要的答案,所以在这里跟大家请教下

    11 replies  •  2020-01-21 11:47:55 +08:00
    wework
    wework
    Jan 21, 2020
    1
    Try \%
    manami
    manami
    Jan 21, 2020
    2
    \_
    Waterchestnut
    Waterchestnut
    OP
    Jan 21, 2020
    3
    @wework 感谢老哥~果然可以~
    Waterchestnut
    Waterchestnut
    OP
    Jan 21, 2020
    4
    @manami 谢谢老哥,这个方法可行~
    wework
    wework
    Jan 21, 2020
    5
    @Waterchestnut sure , we work , no problem
    manami
    manami
    Jan 21, 2020
    6
    https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
    官方有写到“\_ matches one _ character.”
    wework
    wework
    Jan 21, 2020
    7
    @manami in this case, it is about string escaping
    SjwNo1
    SjwNo1
    Jan 21, 2020
    8
    @wework niu bi
    Waterchestnut
    Waterchestnut
    OP
    Jan 21, 2020
    9
    @wework niu bi,kao pu
    jugelizi
    jugelizi
    Jan 21, 2020
    10
    所以 你在拼接 sql 语句!
    wutongshuVVV
    wutongshuVVV
    Jan 21, 2020
    11
    @jugelizi 盲生发现了华点( doge
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Privacy   ·   Solana   ·   1701 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 31ms · UTC 10:30 · PVG 18:30 · LAX 02:30 · JFK 05:30
    ♥ Do have faith in what you're doing.