Tsab ntawv teev npe
MySQL databaseCov lus qhia tsis tu ncua ua li cas?MySQL regexp zoo li kev siv
MySQL cov lus qhia tsis tu ncua
Hauv tshooj dhau los peb tau kawm tias MySQL tuaj yeem ua tau TSIS TAU...% rau fuzzy match.
MySQL kuj txhawb kev sib piv ntawm lwm cov kab lus tsis tu ncua, REGEXP tus neeg teb xov tooj siv hauv MySQL rau kev qhia sib piv.
Yog tias koj paub PHP lossis Perl, nws zoo nkauj ncaj, raws li MySQL cov lus qhia tsis tu ncua zoo ib yam li cov ntawv sau no.
Cov qauv tsis tu ncua hauv cov lus hauv qab no tuaj yeem siv rau REGEXP tus neeg teb xov tooj.
| Hom | 描述 |
|---|---|
| ^ | Matches qhov pib ntawm txoj hlua input.^ kuj tseem phim txoj haujlwm tom qab '\n' lossis '\r' yog tias cov cuab yeej Multiline ntawm RegExp cov khoom raug teeb tsa. |
| $ | Haum rau qhov kawg ntawm txoj hlua input.Yog hais tias cov cuab yeej Multiline ntawm RegExp cov khoom raug teeb tsa, $ kuj phim txoj haujlwm ua ntej '\n' lossis '\ r'. |
| . | Sib phim ib tus cim tshwj tsis yog "\n".Txhawm rau kom phim txhua tus cim suav nrog '\n', siv tus qauv zoo li '[.\n]'. |
| [...] | sau cov cim.Sib phim ib qho ntawm cov cim uas muaj.Piv txwv li, '[abc]' yuav phim "plai'ib' n". |
| [^…] | Negative cim teeb.Sib phim txhua tus cim tsis muaj.Piv txwv li, '[^abc]' yuav phim 'p' hauv "plain". |
| p1 | p2 | p3 | Sib piv p1 lossis p2 lossis p3.Piv txwv li, 'z|food' yuav phim "z" lossis "zaub mov". '(z|f)ood' matches "zood" or "food". |
| * | Matches lub subexpression ua ntej zero los yog ntau zaus.Piv txwv li, zo * yuav phim "z" thiab "zoo". * yog sib npaug rau {0,}. |
| + | Sib piv cov lus hais ua ntej ib lossis ntau zaus.Piv txwv li, 'zo +' yuav phim "zo" thiab "zoo", tab sis tsis yog "z". + yog sib npaug rau {1,}. |
| {n} | n yog ib tug tsis-negative integer.Ua tau raws nraim n lub sij hawm.Piv txwv li, 'o{2}' yuav tsis phim 'o' hauv "Bob", tab sis yuav phim ob qho tib si hauv "khoom noj". |
| {n, m} | Ob leeg m thiab n yog cov lej tsis zoo, qhov twg n <= m.Sib tw tsawg kawg n zaug thiab feem ntau m zaus. |
piv txwv
Tom qab nkag siab txog cov kev cai saum toj no, peb tuaj yeem sau SQL nqe lus nrog cov lus hais raws li peb tus kheej xav tau.Hauv qab no peb yuav sau qee qhov piv txwv me me (lub npe rooj: person_tbl ) kom nkag siab tob rau peb:
Nrhiav tag nrho cov ntaub ntawv pib nrog 'st' hauv lub npe teb:
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^st';
Nrhiav tag nrho cov ntaub ntawv uas xaus nrog 'ok' hauv lub npe teb:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'ok$';
Nrhiav tag nrho cov ntaub ntawv uas muaj 'mar' hlua hauv lub npe teb:
mysql> SELECT name FROM person_tbl WHERE name REGEXP 'mar';
Nrhiav tag nrho cov ntaub ntawv nyob rau hauv lub npe teb uas pib nrog ib tug vowel cim los yog xaus nrog cov hlua 'ok':
mysql> SELECT name FROM person_tbl WHERE name REGEXP '^[aeiou]|ok$';
Cia siab Chen Weiliang Blog ( https://www.chenweiliang.com/ ) qhia "Yuav ua li cas phim MySQL database cov lus qhia ib txwm muaj? MySQL regexp zoo li kev siv" yuav pab koj.
Zoo siab txais tos los qhia qhov txuas ntawm kab lus no:https://www.chenweiliang.com/cwl-492.html
Zoo siab txais tos rau Telegram channel ntawm Chen Weiliang blog kom tau txais qhov hloov tshiab tshiab!
📚 Daim ntawv qhia no muaj nuj nqis loj, 🌟Qhov no yog lub sijhawm tsis tshua muaj, tsis txhob nco nws! ⏰⌛💨
Share thiab like yog tias koj nyiam!
Koj qhov kev sib koom thiab kev nyiam yog peb qhov kev txhawb nqa tas mus li!