Isalathiso senqaku
MySQL databaseIngaba imbonakalo eqhelekileyo idibana njani?MySQL regexp njengosetyenziso
Iintetho eziqhelekileyo ze-MySQL
Kwizahluko ezidlulileyo sibonile ukuba i-MySQL ingaba THANDA...% kuthelekiseka okungenantsingiselo.
I-MySQL ikwaxhasa ukudityaniswa kwamanye amabinzana aqhelekileyo.Umsebenzisi we-REGEXP usetyenziswa kwi-MySQL yongqamaniso lwentetho eqhelekileyo.
Ukuba uyayazi i-PHP okanye i-Perl, ilula kakhulu, njengoko i-MySQL ibonakaliso eqhelekileyo iyafana naleyo yezi scripts.
Iipateni eziqhelekileyo kule theyibhile ilandelayo zingasetyenziswa kumsebenzisi we-REGEXP.
模式 | inkcazo |
---|---|
^ | Itshatisa isiqalo somtya wegalelo.^ kwakhona idibanisa indawo emva kwe '\n' okanye '\r' ukuba ipropati ye-Multiline ye-RegExp isetyenzisiwe. |
$ | Itshatisa isiphelo somtya wegalelo.Ukuba iMultiline ipropathi yeRegExp isetyenzisiwe, i-$ ikwangqamana nendawo phambi kokuba '\n' okanye '\r'. |
. | Itshatisa nawuphi na unobumba omnye ngaphandle kokuthi "\n".Ukutshatisa nawuphi na umsebenzi oquka '\n', sebenzisa ipateni efana ne-'[.\n]'. |
[...] | ingqokelela yabalinganiswa.Itshatisa nawuphi na omnye wabalinganiswa abaqulethweyo.Umzekelo, '[abc]' ingangqamanisa "plai'a' kwi-n". |
[...] | Iseti yoonobumba abalandulayo.Itshatisa nawuphi na umsebenzi ongaqulathwanga.Umzekelo, '[^abc]' ingangqamanisa u-'p' ku-"plain". |
p1|p2|p3 | Tshatisa p1 okanye p2 okanye p3.Umzekelo, 'z|ukutya' kungangqamana nokuba ngu-"z" okanye "ukutya". '(z|f)ood' idibanisa "zood" okanye "ukutya". |
* | Itshatisa ibinzana langaphambili elinguziro okanye amaxesha amaninzi.Umzekelo, u-zo* angatshatisa u-"z" kunye no-"zoo". * ilingana no- {0,}. |
+ | Itshatisa ibinzana langaphambili elinye okanye amaxesha amaninzi.Umzekelo, u-'zo+' unokutshatisa u-"zo" kunye no-"zoo", kodwa hayi u-"z". + ilingana no- {1,}. |
{n} | n yi-non-negative integer.Idibanisa ngokuthe ngqo n amaxesha.Umzekelo, u-'o{2}' akanakungqamana no-'o' ku-"Bob", kodwa izakuthelekisa zombini ezi 'o' ku-"ukutya". |
{n, m} | Zombini u-m kunye no-n zii-non-negative integers, apho u-n <= m.Itshatisa ubuncinci amaxesha n kwaye ngamaxesha amaninzi m. |
Umzekelo
Emva kokuqonda ezi mfuno ziqhelekileyo zingasentla, sinokubhala iinkcazo zeSQL ngamabinzana aqhelekileyo ngokweemfuno zethu.Ngezantsi siza kudwelisa imizekelo emincinci embalwa (igama letheyibhile: person_tbl ) ukwenza nzulu ukuqonda kwethu:
Fumana yonke idatha eqala ngo-'st' kwindawo yegama:
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^st';
Fumana yonke idatha ephela ngo 'ok' kwindawo yegama:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'ok$';
Fumana yonke idatha equlethe umtya othi 'mar' kwindawo yegama:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'mar';
Fumana yonke idatha kwindawo yegama eqala ngophawu lwesikhamiso okanye ephela ngoluhlu lwamagama 'ok':
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^[aeiou]|ok$';
Ndiyathemba Chen Weiliang Blog ( https://www.chenweiliang.com/ ) kwabelwana "Indlela yokuthelekisa isiseko sedatha yeMySQL rhoqo? I-MySQL regexp njengosetyenziso" iya kukunceda.
Wamkelekile ukwabelana ngekhonkco leli nqaku:https://www.chenweiliang.com/cwl-492.html
Wamkelekile kwisitishi seTelegram sebhlog kaChen Weiliang ukufumana uhlaziyo lwamva nje!
📚 Esi sikhokelo sinexabiso elikhulu, 🌟Eli lithuba elinqabileyo, ungaliphoswa! ⏰⌛💨
Yabelana kwaye uthanda ukuba uyathanda!
Ukwabelana kwakho kunye nezinto ozithandayo ziyinkuthazo yethu eqhubekayo!