{"id":189,"date":"2009-02-15T18:02:53","date_gmt":"2009-02-16T01:02:53","guid":{"rendered":"https:\/\/actionsnippet.com\/?p=786"},"modified":"2009-02-15T18:02:53","modified_gmt":"2009-02-16T01:02:53","slug":"mysql-soundex","status":"publish","type":"post","link":"https:\/\/actionsnippet.com\/?p=189","title":{"rendered":"MYSQL SOUNDEX"},"content":{"rendered":"<pre class=\"brush: cpp; title: ; notranslate\" title=\"\">\r\nSELECT * FROM _users WHERE SOUNDEX(name) LIKE SOUNDEX(&#039;jon&#039;);\r\n<\/pre>\n<p>Not ActionScript, but the coolest thing I&#8217;ve seen in Mysql in awhile, the soundex function will convert a string into a soundex index&#8230; read more about it on <a href=\"http:\/\/en.wikipedia.org\/wiki\/Soundex\">wikipedia<\/a>. <\/p>\n<p>I did some tests and it matches things like:<\/p>\n<p>what&#8217;s your name?   &#038; whats yer name<\/p>\n<p>very cool&#8230; since this isn&#8217;t ActionScript, I will post another snippet right after this.<\/p>\n<p>UPDATE: Actually started reading more about this stuff and dug up some algorithms&#8230; metaphone etc&#8230; fun stuff, maybe I&#8217;ll port some of it to actionscript&#8230;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT * FROM _users WHERE SOUNDEX(name) LIKE SOUNDEX(&#039;jon&#039;); Not ActionScript, but the coolest thing I&#8217;ve seen in Mysql in awhile, the soundex function will convert a string into a soundex index&#8230; read more about it on wikipedia. I did some tests and it matches things like: what&#8217;s your name? &#038; whats yer name very cool&#8230; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[94,20,21],"tags":[],"class_list":["post-189","post","type-post","status-publish","format-standard","hentry","category-misc","category-string-manipulation","category-strings"],"_links":{"self":[{"href":"https:\/\/actionsnippet.com\/index.php?rest_route=\/wp\/v2\/posts\/189","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/actionsnippet.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/actionsnippet.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/actionsnippet.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/actionsnippet.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=189"}],"version-history":[{"count":0,"href":"https:\/\/actionsnippet.com\/index.php?rest_route=\/wp\/v2\/posts\/189\/revisions"}],"wp:attachment":[{"href":"https:\/\/actionsnippet.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/actionsnippet.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/actionsnippet.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}