如何提取具有特定行值但行值在数组中的特定数据库行？
问题描述：
I have this database row from where I need to pull the database row only with specific row value such as template_number == 'template-1'. And the row value is in array similar to this
a:1:{s:11:"design";a:5:{s:19:"style";s:7:"default";s:15:"template_number";s:10:"template-4";s:20:"custom_template_type";s:1:"1";s:14:"menu_placement";s:5:"right";}}
我有这个数据库行，我只需要使用特定的行值来拉取数据库行，例如template_number == “模板1”。 并且行值在数组中类似于 p>
a：1：{s：11：“design”; a：5：{s：19：“style”; S：7： “默认”; S：15： “template_number”; S：10： “模板-4”; S：20： “custom_template_type”; S：1： “1”; S：14： “menu_placement”; s：5：“正确”;}}
code> pre>
div>
答
Your question sounded like you want to pick a row which have value that you desire, so maybe its like this :
select * from table where column1='value'
and you will get data by text formated