dongshai8330 2018-02-01 19:56
浏览 419
已采纳

正则表达式mysql查询特定的字符串

hello i am trying to search ddw_0_op1 with mysql regex serach query

SELECT * FROM wp_postmeta WHERE meta_key RLIKE '(?=.*ddw_)(?=.*_op1)'

but in results its also displaying results from this field

_ddw_0_op1

but i want to display results only from this field ddw_0_op1 . how i can achieve that enter image description here in this picture i want results from http links field i hope that makes sense now

  • 写回答

1条回答 默认 最新

  • doulaozhi6835 2018-02-10 02:31
    关注

    With INDEX(meta_key), this may be faster:

    WHERE meta_key LIKE   'ddw_%_op1'
      AND meta_key RLIKE '^ddw_[[:digit:]]+_op1$'
    

    First the LIKE (without a leading wildcard) can use the index. Then the RLIKE will verify that only digits are in the middle (without using the index).

    Since this smells like a WP schema, here are some more tips on wp_postmeta. (The tips won't speed up your ddw query, but may help others.)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥30 Hyper-v虚拟机相关问题,求解答。
  • ¥15 TSM320F2808PZA芯片 Bootloader
  • ¥45 谷歌浏览器出现开发者工具无法显示已创建的,但您可以调试已部署的代码。 状态代码 404, net::ERR HTTP RESPONSE CODE FAILURE
  • ¥15 chatgpt网页版侧边栏和模型切换点击没反应怎么办
  • ¥15 如何解决蓝牙通话音频突发失真问题
  • ¥15 安装opengauss数据库报错
  • ¥15 【急】在线问答CNC雕刻机的电子电路与编程
  • ¥60 在mc68335芯片上移植ucos ii 的成功工程文件
  • ¥15 笔记本外接显示器正常,但是笔记本屏幕黑屏
  • ¥15 Python pandas