Uhla lwemibhalo ye-athikili
MySQL databaseIngabe ukusho okuvamile kufana kanjani?MySQL regexp njengokusetshenziswa
Izinkulumo ezijwayelekile ze-MySQL
Ezahlukweni ezedlule sibonile ukuthi i-MySQL ingaba THANDA...% ukufanisa okungacacile.
I-MySQL iphinde isekele ukufaniswa kwezinye izisho ezivamile.I-opharetha ye-REGEXP isetshenziswa ku-MySQL ukuze kufaniswe isisho esivamile.
Uma uyayazi i-PHP noma i-Perl, iqonde ngqo, njengoba ukufanisa okujwayelekile kwe-MySQL kufana nalezi mibhalo.
Amaphethini avamile kuthebula elilandelayo angasetshenziswa ku-opharetha we-REGEXP.
Imodi | incazelo |
---|---|
^ | Ifanisa ukuqala kweyunithi yezinhlamvu yokokufaka.^ iphinda ifane nendawo engemuva kokuthi '\n' noma '\r' uma isici se-Multiline sento ye-RegExp isethiwe. |
$ | Ifanisa isiphetho seyunithi yezinhlamvu yokokufaka.Uma isakhiwo se-Multiline sento ye-RegExp sisethiwe, i-$ iphinda ifane nendawo ngaphambi kokuthi '\n' noma '\r'. |
. | Ifanisa nanoma yiluphi uhlamvu olulodwa ngaphandle kokuthi "\n".Ukuze ufanise nanoma yiluphi uhlamvu oluhlanganisa u-'\n', sebenzisa iphethini efana ne-'[.\n]'. |
[...] | ukuqoqwa kwezinhlamvu.Ifanisa nanoma iyiphi enye yezinhlamvu eziqukethwe.Isibonelo, i-'[abc]' ingafana ne-"plai'a' ku-n". |
[^…] | Isethi yezinhlamvu ezingezinhle.Ifanisa nanoma yiluphi uhlamvu olungaqukethwe.Isibonelo, u-'[^abc]' angafanisa 'p' kokuthi "plain". |
p1|p2|p3 | Ifanisa i-p1 noma i-p2 noma i-p3.Isibonelo, 'z|ukudla' kungafana no-"z" noma "ukudla". I-'(z|f)ood' ifana ne-"zood" noma "ukudla". |
* | Ifana nenkulumo engaphansi edlule uziro noma izikhathi eziningi.Isibonelo, i-zo* ingafanisa okuthi "z" kanye "ne-zoo". * ilingana nokuthi {0,}. |
+ | Ifana nenkulumo engaphansi eyandulele kanye noma ngaphezulu.Isibonelo, i-'zo+' ingafanisa "zo" kanye "zoo", kodwa hhayi "z". + kulingana nokuthi {1,}. |
{n} | n iyinombolo engeyona inegethivu.Ifana ncamashi izikhathi n.Isibonelo, u-'o{2}' ngeke afane no-'o' kokuthi "Bob", kodwa uzofanisa kokubili o-o kokuthi "ukudla". |
{n,m} | Kokubili u-m no-n angama-non-negative izinombolo, lapho n <= m.Ifanisa okungenani izikhathi ezingu-n futhi izikhathi eziningi m. |
Isibonelo
Ngemva kokuqonda izidingo ezivamile ezingenhla, singabhala izitatimende ze-SQL ngamagama avamile ngokwezidingo zethu.Ngezansi sizoklelisa izibonelo ezimbalwa ezincane (igama lethebula: person_tbl ) ukuze sijulise ukuqonda kwethu:
Thola yonke idatha eqala ngo-'st' endaweni yegama:
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^st';
Thola yonke idatha egcina ngokuthi 'kulungile' endaweni yegama:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'ok$';
Thola yonke idatha equkethe iyunithi yezinhlamvu ethi 'mar' endaweni yegama:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'mar';
Thola yonke idatha endaweni yegama eqala ngohlamvu lukankamisa noma egcina ngochungechunge oluthi 'ok':
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^[aeiou]|ok$';
I-Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabiwe "Indlela yokufanisa izinkulumo ezijwayelekile ze-MySQL database? I-MySQL regexp efana nokusetshenziswa" izokusiza.
Siyakwamukela ukwabelana ngesixhumanisi salesi sihloko:https://www.chenweiliang.com/cwl-492.html
Uyemukelwa esiteshini seTelegram sebhulogi ka-Chen Weiliang ukuze uthole izibuyekezo zakamuva!
📚 Lo mhlahlandlela uqukethe inani elikhulu, 🌟Leli ithuba eliyivelakancane, ungaphuthelwa! ⏰⌛💨
Yabelana futhi uthanda uma uthanda!
Ukwabelana kwakho nokuthanda kwakho kuyisisusa sethu esiqhubekayo!