dqc22586 2017-09-21 23:18
浏览 36
已采纳

用于从mysql中的json_encided列中查找值的sql?

I have a column of json_encoded in my table and want to check a value exist or not in that column. What type of query should write?

Example: I have a column in which values are: ["1","2","3","4"] and I want to check through query that 1 exists or not.

  • 写回答

3条回答 默认 最新

  • duandi8852752 2017-09-21 23:30
    关注

    Try:

    SELECT * FROM `tableName` WHERE Column LIKE '%"1"%';
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 DevEco studio开发工具 真机联调找不到手机设备
  • ¥15 请教前后端分离的问题
  • ¥100 冷钱包突然失效,急寻解决方案
  • ¥15 下载honeyd时报错 configure: error: you need to instal a more recent version of libdnet
  • ¥15 距离软磁铁一定距离的磁感应强度大小怎么求
  • ¥15 霍尔传感器hmc5883l的xyz轴输出和该点的磁感应强度大小的关系是什么
  • ¥15 vscode开发micropython,import模块出现异常
  • ¥20 Excel数据自动录入表单并提交
  • ¥30 silcavo仿真,30分钟,只需要代码
  • ¥15 FastReport 怎么实现打印后马上关闭打印预览窗口