andre Posted August 19, 2005 Report Share Posted August 19, 2005 ir taada probleema ka dazpiem sql pieprasiijumiem deel shiis komandas dalas tiek paraadiiti visi ieraksti un veel nodubleeti. LEFT JOIN destructive_windows ON ( LCASE(log.windtext) LIKE CONCAT('%',LCASE(destructive_windows.windowtext),'%')) and ( log.ID = destructive_windows.ID) kaa var parveidot sho dalu, lai tiktu selektota no log tie ieraksti, kuriem log.windtext sakriit ar destructive_windows.windowtext piemeeram log.windtext = "es esmu klucis konstantiiivs" un ja destructive_windows.windowtext="Klucis", tad selektojaas tas ieraksts. Link to comment Share on other sites More sharing options...
v3rb0 Posted August 19, 2005 Report Share Posted August 19, 2005 no resultata dublesanas vari meginat tikt valjaa ar `group by` bet vai tiesam vajag tik smagu joinu starp diviem texta laukiem ar visiem concat(), like() utt.? Link to comment Share on other sites More sharing options...
andre Posted August 25, 2005 Author Report Share Posted August 25, 2005 no resultata dublesanas vari meginat tikt valjaa ar `group by`bet vai tiesam vajag tik smagu joinu starp diviem texta laukiem ar visiem concat(), like() utt.? 21201[/snapback] grupeeshana ir un veel plus divi joini. nu es gribu uzzinaat kaa bez tiem concat var tikt valaa lai rezultaats buutu tas pats... Link to comment Share on other sites More sharing options...
v3rb0 Posted August 25, 2005 Report Share Posted August 25, 2005 no sql join daljas neviens neko daudz nepatieks kaa bez concat var iztikt, ja neraadi tabulu struktuuru un neapstaasti ko gribi saselecteet. Link to comment Share on other sites More sharing options...
Robis Posted August 25, 2005 Report Share Posted August 25, 2005 andre izskatās pēc kārtēja zīmuļa, kurš lēc pāri par savu galvu ar lietām, kurām pats tā īsti skaidrībā nav :) Link to comment Share on other sites More sharing options...
Analgiins Posted August 25, 2005 Report Share Posted August 25, 2005 Robis nav gadiijumaa taads pats? :) Link to comment Share on other sites More sharing options...
Recommended Posts