Senin, 02 September 2013

PHP Indonesia - Facebook: Help! Regex di MySQL. Kalau ane punya baris data s...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Design-Led Engineering

Sourcebits - When your Mobile App has to be absolutely developed right. We've built more than 20 apps that have cracked the Top 10 in the App Store.
From our sponsors
Help! Regex di MySQL. Kalau ane punya baris data s...
Sep 2nd 2013, 15:40, by Peter Jack Kambey

Peter Jack Kambey 3:40pm Sep 2
Help! Regex di MySQL. Kalau ane punya baris data sprt ini:
nama | anggota_dari
peter | Kelompok I
eksa | Kelompok II, Kelompok III
luri | Kelompok I, Kelompok III
yayan | Kelompok II

Kalau ane mau nyari "Kelompok I" (Kelompok II tidak boleh masuk, meskipun kata Kelompok II Mengandung Kelompok I), jadi cuman "peter dan luri" yang nongol

Select Nama from my_table where anggota_dari REGEXP '........'; //piye?

Peter Jack Kambey 3:41pm Sep 2
colek master regexp Muhammad Nashir, Nur Hidayat..

Wilianto Indrawan 3:47pm Sep 2
SELECT * FROM `table` WHERE anggota_dari REGEXP 'KELOMPOK I$'

Wilianto Indrawan 3:47pm Sep 2
monggo dicoba dulu om

Jati Myw 3:51pm Sep 2
kenapa select stringnya tidak dipakai tenary dulu om? sepertinya lebih mudah

Peter Jack Kambey 3:52pm Sep 2
kumaha tuh bang Jati?...
Wilianto Indrawan.. thx let me try.. tapi isi dari anggota itu bisa beraneka ragam sih.. saya hanya nggak mau nyampur ajeh..

Wilianto Indrawan 3:53pm Sep 2
eh sorry ada yg msh kurang om.
SELECT * FROM `a` WHERE nama REGEXP '^KELOMPOK I(,|$)'

Jati Myw 4:06pm Sep 2
tenary berdasar triggernya utk filter string querynya, tapi pakainya LIKE atau SELECT BINARY, cuma jadinya tidak pakai regex.. tapi sepertinya solusinya diatas ane mantebs utk regex.

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar