Chinyorwa Directory
MySQL databaseMatauriro enguva dzose anowirirana sei?MySQL regexp sekushandisa
MySQL yenguva dzose kutaura
Muzvitsauko zvakapfuura takadzidza kuti MySQL inogona kupfuura KUDA...% nokuda kwekuenzanisa kwakaoma.
MySQL inotsigirawo kuenzanirana kwemamwe mataurirwo enguva dzose.Mushandisi weREGEXP anoshandiswa muMySQL pakuita kuenzanisa kwemaitiro enguva dzose.
Kana iwe uchiziva PHP kana Perl, yakatwasuka, sezvo MySQL yenguva dzose yekutaura inoenderana yakafanana neiyo yeaya zvinyorwa.
Iwo enguva dzose mapatani mutafura inotevera anogona kuiswa kune REGEXP anoshanda.
| Mode | tsananguro |
|---|---|
| ^ | Inofananidzwa nekutanga kwetambo yekupinda.^ zvakare inofananidza chinzvimbo mushure me'\n' kana '\r' kana Multiline pfuma yeRegExp chinhu chaiswa. |
| $ | Inofananidza kupera kwetambo yekupinda.Kana iyo Multiline pfuma yeRegExp chinhu chaiswa, $ zvakare inofananidza chinzvimbo pamberi '\n' kana '\r'. |
| . | Inofananidzira chero mavara kunze kwe "\n".Kuti uenderane nemavara ese anosanganisira '\n', shandisa pateni yakaita se'[.\n]'. |
| [...] | muunganidzwa wemavara.Inofananidzira chero mavara arimo.Semuenzaniso, '[abc]' ingaenderana ne "plai'a' mu n". |
| [^…] | Negative character set.Inoenderana nechero mavara asina.Semuenzaniso, '[^abc]' ingaenderane 'p' mu "plain". |
| p1|p2|p3 | Inofananidza p1 kana p2 kana p3.Semuyenzaniso, 'z|chikafu' chingaenderana ne "z" kana "chikafu". '(z|f)ood' inofanana ne "zood" kana "chikafu". |
| * | Inofambirana nechirevo chapfuura zero kana kupfuura nguva.Semuenzaniso, zo* ingaenderana ne "z" pamwe ne "zoo". * yakaenzana ne{0,}. |
| + | Inofambirana nemazwi adarika kamwechete kana kupfuura.Semuenzaniso, 'zo+' ingaenderane "zo" ne "zoo", asi kwete "z". + inofanana ne{1,}. |
| {n} | n is a non-negative integer.Machisa chaiwo n nguva.Semuyenzaniso, 'o{2}' haingaenderani ne'o' muna "Bob", asi inofananidzira mao ese ari mu"chikafu". |
| {n,m} | Ose m na n haana-negative nhamba, apo n <= m.Matches kanenge n nguva uye kazhinji m nguva. |
muenzaniso
Mushure mekunzwisisa zviri pamusoro zvinodikanwa zvenguva dzose, tinogona kunyora SQL zvirevo nezvirevo zvenguva dzose zvinoenderana nezvatinoda.Pazasi isu tinonyora mishoma mienzaniso midiki (tafura zita: person_tbl ) kudzamisa kunzwisisa kwedu:
Tsvaga data rese kutanga ne 'st' mundima yezita:
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^st';
Tsvaga data rese rinopera ne 'ok' mundima yezita:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'ok$';
Tsvaga data rese rine 'mar' tambo mundima yezita:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'mar';
Tsvaga data rese mundima yezita rinotanga nemavara evhawero kana rinopera netambo 'ok':
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^[aeiou]|ok$';
Hope Chen Weiliang Blog ( https://www.chenweiliang.com/ ) yakagovaniswa "Sei yekufananidza MySQL dhatabhesi yenguva dzose mataurirwo? MySQL regexp sekushandisa" ichakubatsira.
Welcome to share link yechinyorwa chino:https://www.chenweiliang.com/cwl-492.html
Tikugashirei kuTeregiramu chiteshi cheChen Weiliang's blog kuti uwane zvichangobva kuitika!
📚 Iri gwara rine kukosha kukuru, 🌟Uyu mukana usingawanzo, usapotsa! ⏰⌛💨
Govera uye like kana uchida!
Kugovera kwako uye kuda ndiko kukurudzira kwedu kunoramba kuripo!