在内部使用MYSQL序列化数据 [英] Search inside serialize data with MYSQL

问题描述

我想在序列化数组中搜索，数据看起来像:

I'd like to search inside serialized array, data look like :

a:7:{i:0;s:2:"34";i:1;s:1:"0";i:2;s:2:"42";i:3;s:2:"33";i:4;s:2:"48";i:5;s:2:"62";i:6;s:2:"47";}

我尝试过:

$id_serialize = '"'.$id.'"';
$req = requette("SELECT id FROM table WHERE col LIKE '%$id_serialize%'"); 

但是它不起作用，有什么解决办法吗? 谢谢.

But it's not working, any solution? Thanks.

推荐答案

您的查询格式有误.如果您尝试将$id_serialize传递给您的查询，则需要采用以下格式:

Your query is formatted a little wrong. If you are trying to pass $id_serialize to your query, it needs to be formatted like this:

$id_serialize = $id;
$req = requette("SELECT id FROM table WHERE col LIKE '%" . $id_serialize . "%'");

这篇关于在内部使用MYSQL序列化数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！