{"id":664,"date":"2013-03-18T21:10:47","date_gmt":"2013-03-19T02:10:47","guid":{"rendered":"http:\/\/blog.xfloyd.net\/?p=664"},"modified":"2013-03-18T21:10:47","modified_gmt":"2013-03-19T02:10:47","slug":"mysql-comma-delimited-string-can-work-just-fine","status":"publish","type":"post","link":"https:\/\/xfloyd.net\/blog\/?p=664","title":{"rendered":"MYSQL comma delimited string can work just fine!"},"content":{"rendered":"<p>Do not serialize, just\u00a0comma delimite your strings, and your SQL will be happy.<br \/>\nYou need the FIND_IN_SET function:<\/p>\n<pre>\r\nSELECT ... WHERE FIND_IN_SET('1', field)\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Do not serialize, just\u00a0comma delimite your strings, and your SQL will be happy. You need the FIND_IN_SET function: SELECT &#8230; WHERE FIND_IN_SET(&#8216;1&#8217;, field)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/664"}],"collection":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=664"}],"version-history":[{"count":2,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/664\/revisions"}],"predecessor-version":[{"id":668,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=\/wp\/v2\/posts\/664\/revisions\/668"}],"wp:attachment":[{"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=664"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=664"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xfloyd.net\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}