如何从mysql数据库的序列化字段中搜索? [英] How do i search from serialize field in mysql database?
本文介绍了如何从mysql数据库的序列化字段中搜索?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我如何从mysql数据库中除mysql like语句以外的序列化字段中搜索?
How do i search from serialize field in mysql database except mysql like statement?
数据为:
a:9:{s:2:"m1";s:4:"1217";s:2:"m2";s:8:"9986-961";s:2:"m3";s:19:"1988-03-07 00:00:00";s:2:"m4";s:0:"";s:2:"m5";s:0:"";s:2:"m6";s:0:"";s:2:"m7";s:3:"104";s:2:"m8";s:6:"150000";s :2:"m9";s:18:"Ok Then, Yes It Is";}
我需要m9值是'Yes It Is'的行.我不想使用mysql'like'语句.
I need the row in which the m9 value is 'Yes It Is'. I do not want to use mysql 'like' statement.
我尝试过:
SELECT * FROM table WHERE field like '%Yes It Is%'
可以请你帮忙.
推荐答案
我发现了一种使用正则表达式的解决方案:
I have found one solution using regular expression :
SELECT *
FROM table_name
WHERE `field` REGEXP '.*"array_key";s:[0-9]+:".*array_value.*".*'
SELECT *
FROM table_name
WHERE `field` REGEXP '.*"m9";s:[0-9]+:".*Ok Then, Yes It Is.*".*'
希望这会有所帮助:
http://www.namasteui.com/search -from-serialize-field-in-mysql-database/
这篇关于如何从mysql数据库的序列化字段中搜索?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文