dewi_biru 0 Report post Posted October 15, 2005 hiii...saya ader problem..saya gune postgresql..camner nak extract string dari dalam recordcth:/laporan/projek=123.php?laporansemasa&ruj_projek=12345678saya nak extract string '%ruj_%'.cth:ruj_projek=12345678masalahnya..dlm record...susunan array tak sama..sbb saya dah try gune substr..string_to_array...trim..takleh gak..cume certain record jer yang boleh displaykalau gune php..mmg bende nih boleh setel..gune split..ader lagi cara lain..sekarang saya nak cube buat menggunakan postgresql..tima kacih pada yg sudi tulun:) Quote Share this post Link to post Share on other sites
step 0 Report post Posted October 18, 2005 Dah try LIKE Operator??Like '%ruj_%' Quote Share this post Link to post Share on other sites
dewi_biru 0 Report post Posted October 19, 2005 Dah try LIKE Operator??Like '%ruj_%'←like %ruj_% saya gune untuk pilih record yang ada ruj_ sahaja..lps tuh saya nak extract perkataan ruj_ sahaja dr record tu..then akan dipaparkan dalam column yang lain....saya boleh buat..tp kene gune php script..saya nak try gune postgres jer..harap ader yang sudi tulun:) Quote Share this post Link to post Share on other sites
1kHz 0 Report post Posted October 19, 2005 masalahnya..dlm record...susunan array tak sama..apa ni? tak faham. Array apa pula ni?Dalam postgres ada regular expression function tak? Benda mcm ni probably boleh extract guna regex. Quote Share this post Link to post Share on other sites
dewi_biru 0 Report post Posted October 19, 2005 apa ni? tak faham. Array apa pula ni?Dalam postgres ada regular expression function tak? Benda mcm ni probably boleh extract guna regex.←mekacih bg suggestion..mmg ader reg expression..tp kene guner array kan?saya dah try..masalahnyer..perkataan ruj_ tuh berterabur..tak ikut susunan..so saya tak tau nak estimate array dier..mm.mayb saya yg kureng cket ilmu nih:P..well ader suggestion lain? Quote Share this post Link to post Share on other sites