Gweilo
27.12.2002, 10:03:25
Weiss jemand, wieso folgendes Query geht, und das nächste nicht mehr?
SELECT COUNT(*) FROM bilder WHERE prog NOT LIKE '%max%' and prog NOT LIKE '%bryce%' and prog NOT LIKE '%lightwave%' and prog NOT LIKE '%pov%' and prog NOT LIKE '%cinema%' and prog NOT LIKE '%c4d%' and prog NOT LIKE '%maya%' and prog NOT LIKE '%poser%'
SELECT id,image,pkt_avg,title,user FROM bilder WHERE prog NOT LIKE '%max%' and prog NOT LIKE '%bryce%' and prog NOT LIKE '%lightwave%' and prog NOT LIKE '%pov%' and prog NOT LIKE '%cinema%' and prog NOT LIKE '%c4d%' and prog NOT LIKE '%maya% and prog NOT LIKE '%poser%' ORDER BY pkt_avg DESC
Der Count befehl zählt hierbei 13 elemente, beim selecten findet er kein einzigen Treffer?! weiss jemand, warum das so ist? Gibt es dafür eine Lösung?
SELECT COUNT(*) FROM bilder WHERE prog NOT LIKE '%max%' and prog NOT LIKE '%bryce%' and prog NOT LIKE '%lightwave%' and prog NOT LIKE '%pov%' and prog NOT LIKE '%cinema%' and prog NOT LIKE '%c4d%' and prog NOT LIKE '%maya%' and prog NOT LIKE '%poser%'
SELECT id,image,pkt_avg,title,user FROM bilder WHERE prog NOT LIKE '%max%' and prog NOT LIKE '%bryce%' and prog NOT LIKE '%lightwave%' and prog NOT LIKE '%pov%' and prog NOT LIKE '%cinema%' and prog NOT LIKE '%c4d%' and prog NOT LIKE '%maya% and prog NOT LIKE '%poser%' ORDER BY pkt_avg DESC
Der Count befehl zählt hierbei 13 elemente, beim selecten findet er kein einzigen Treffer?! weiss jemand, warum das so ist? Gibt es dafür eine Lösung?