Changes between Version 4 and Version 5 of simpleSearch

Timestamp:

Apr 20, 2007, 9:02:35 AM (17 years ago)

Author:

dwinter

Comment:

--

simpleSearch

@@ -61 +61 @@
 </form>
 }}}
+
+Ergibt als Statement mit dem Suchstring "camera lucida hoffmann":
+
+{{{
+select i.filename as filename, j.* from  simple_search 
+v left outer join vision_images i on (v.id_image = i.id) 
+left outer join vision_main j on (v.id_image = j.id_image)  
+where lower(simple_search) like '%camera%' and v.id_image in
+(select v.id_image from  simple_search v where lower(simple_search) like '%lucida%' 
+intersect 
+select v.id_image from  simple_search v where lower(simple_search) like '%hoffmann%')
+
+}}}