{"id":905,"date":"2023-06-08T12:07:32","date_gmt":"2023-06-08T12:07:32","guid":{"rendered":"https:\/\/tarkvara.thkit.ee\/veeb\/?page_id=905"},"modified":"2023-06-08T12:07:32","modified_gmt":"2023-06-08T12:07:32","slug":"pikemad-paringud","status":"publish","type":"page","link":"https:\/\/tarkvara.thkit.ee\/veeb\/pikemad-paringud\/","title":{"rendered":"Pikemad p\u00e4ringud"},"content":{"rendered":"\n

LIKE<\/h4>\n\n\n\n

Tekstidest otsimise juures aitab sobivat vastet leida v\u00f5rdlus LIKE. Kui sinna anda ette lihtsalt tekst, siis k\u00e4itub LIKE v\u00f5rdusm\u00e4rgina:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

K\u00e4skluse p\u00f5hiv\u00f5lu seisneb aga v\u00f5imaluses otsida metam\u00e4rkide j\u00e4rgi. Alljoon _ t\u00e4histab \u00fchte suvalist s\u00fcmbolit ning protsendim\u00e4rk % suvalist arvu suvalisi s\u00fcmboleid. N\u00e4iteks S% vastab k\u00f5igile tekstidele, mis algavad S-iga.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Ning %s% vastab k\u00f5igile tekstidele, mis sisaldavad s-i.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Alljoon, nagu \u00f6eldud, vastab vaid \u00fchele s\u00fcmbolile.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Nii et kui nimeks olnuks Pets, siis sinna \u2018_ts\u2019 ei laiene.<\/p>\n\n\n\n

Ette saab anda ka t\u00e4htede loetelu \u2013 selleks vajalikud kandilised sulud. \u2018%[tr]i\u2019 t\u00e4hendab, et alguses v\u00f5ivad olla suvalised s\u00fcmbolid, siis peab tulema t v\u00f5i r ning l\u00f5ppu i. Nagu n\u00e4ha \u2013 selliseid nimesid on meie loetelus p\u00e4ris mitu.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

LIKE v\u00f5tab arvutilt k\u00fcllalt palju m\u00f5tlemisaega \u2013 seet\u00f5ttu ei soovitata suuremate tabelite juures vastavat k\u00e4sklust ilmaasjata pruukida. Samas aga on see k\u00fcllalt mugav vahend sobivate nimede ja koodide leidmiseks, nii et m\u00f5\u00f5duka kasutamise juures on ta t\u00e4iesti omal kohal.<\/p>\n\n\n\n

Pikemate, n\u00f6 t\u00e4istekstide juures, on SQL-serveril omad k\u00e4sud CONTAINS ning FREETEXT, mille abil v\u00f5imalik omale sobivaid andmeid k\u00e4tte saada.<\/p>\n\n\n\n

Kuna t\u00e4isteksti otsinguid ei tee mitte SQL Server vaid Windowsi Indekseerimise ja otsimise teenus siis vajab nende funktsioonide kasutamine administraatori poolset andmete ettevalmistust ning hoolitust.<\/p>\n","protected":false},"excerpt":{"rendered":"

LIKE Tekstidest otsimise juures aitab sobivat vastet leida v\u00f5rdlus LIKE. Kui sinna anda ette lihtsalt tekst, siis k\u00e4itub LIKE v\u00f5rdusm\u00e4rgina: K\u00e4skluse p\u00f5hiv\u00f5lu seisneb aga v\u00f5imaluses otsida metam\u00e4rkide j\u00e4rgi. Alljoon _ t\u00e4histab \u00fchte suvalist s\u00fcmbolit ning protsendim\u00e4rk % suvalist arvu suvalisi s\u00fcmboleid. N\u00e4iteks S% vastab k\u00f5igile tekstidele, mis algavad S-iga. Ning %s% vastab k\u00f5igile tekstidele, mis … Loe edasi Pikemad p\u00e4ringud<\/span> →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-905","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/905","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/comments?post=905"}],"version-history":[{"count":1,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/905\/revisions"}],"predecessor-version":[{"id":916,"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/pages\/905\/revisions\/916"}],"wp:attachment":[{"href":"https:\/\/tarkvara.thkit.ee\/veeb\/wp-json\/wp\/v2\/media?parent=905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}