{"id":146,"date":"2009-03-09T13:36:18","date_gmt":"2009-03-09T13:36:18","guid":{"rendered":"http:\/\/syarman.com\/soft\/?p=146"},"modified":"2009-03-18T05:56:34","modified_gmt":"2009-03-18T05:56:34","slug":"ekstrak-nama-domain-dari-email","status":"publish","type":"post","link":"http:\/\/syarman.com\/soft\/2009\/03\/09\/ekstrak-nama-domain-dari-email\/","title":{"rendered":"Ekstrak nama domain dari email"},"content":{"rendered":"<p>Asalnya soalan ini ditanyakan di forum komuniti <a href=\"http:\/\/php.net.my\">http:\/\/php.net.my<\/a> . Bagaimana mahu mengekstrak nama domain dari email yang tersimpan didalam pangkalan data(<em>database<\/em>) MySQL.<\/p>\n<p>Ini merupakan contoh jadual (<em>table<\/em>) di dalam pangkalan data.<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nCREATE TABLE `emails` (\r\n`id` INT NOT NULL AUTO_INCREMENT ,\r\n`email` TEXT NOT NULL ,\r\nPRIMARY KEY ( `id` ) \r\n) ENGINE = MYISAM;\r\n<\/pre>\n<p>Ini pula contoh data yang ada di dalam meja.<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nINSERT INTO `emails` (\r\n`id` ,\r\n`email` \r\n)\r\nVALUES (\r\nNULL , 'foo@foobar.com'\r\n), (\r\nNULL , 'fii@fii.com.my'\r\n);\r\n<\/pre>\n<p>Cara untuk menyelesaikan permasalahan ini ialah dengan menggunakan sintak SQL seperti di bawah.<\/p>\n<pre class=\"brush: sql; title: ; notranslate\" title=\"\">\r\nSELECT email,\r\nCONCAT('www.',\r\nSUBSTRING_INDEX(email,'@',-1)\r\n) AS domain\r\nFROM emails;\r\n<\/pre>\n<p>Penggunaan CONCAT adalah untuk menggabungkan nilai-nilai yang ada. Manakala penggunaan fungsi SUBSTRING_INDEX pula untuk memisahkan nilai yang\u00a0ada. Dalam kes ini untuk mendapatkan nilai selepas simbol @.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Asalnya soalan ini ditanyakan di forum komuniti http:\/\/php.net.my . Bagaimana mahu mengekstrak nama domain dari email yang tersimpan didalam pangkalan data(database) MySQL. Ini merupakan contoh jadual (table) di dalam pangkalan data. CREATE TABLE `emails` ( `id` INT NOT NULL AUTO_INCREMENT , `email` TEXT NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,13],"tags":[],"class_list":["post-146","post","type-post","status-publish","format-standard","hentry","category-database","category-mysql"],"_links":{"self":[{"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/posts\/146","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/comments?post=146"}],"version-history":[{"count":2,"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/posts\/146\/revisions"}],"predecessor-version":[{"id":163,"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/posts\/146\/revisions\/163"}],"wp:attachment":[{"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/media?parent=146"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/categories?post=146"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/syarman.com\/soft\/wp-json\/wp\/v2\/tags?post=146"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}