Changes between Version 16 and Version 17 of ImportantUsecase2

Timestamp:

01/13/22 18:58:23 (2 years ago)

Author:

193270

Comment:

--

ImportantUsecase2

@@ -35 +35 @@
 join izdava as i on i.id_knigi=kn.id_na_kniga
 join avtor as a on a.id_na_avtor=i.id_avtor
-where a.ime = 'Frosina Parmakovska';
+where a.ime like '%Frosina Parmakovska%';
 }}}
 
@@ -42 +42 @@
 join e_od as e on e.id_knigi=kn.id_na_kniga
 join kategorija as k on k.id_na_kategorija=e.id_na_kategorija
-where k.ime_kategorija = 'roman';
+where k.ime_kategorija like '%roman%';
 }}}
 == Чекор 4
@@ -55 +55 @@
 join izdava as i on i.id_knigi=kn.id_na_kniga
 join avtor as a on a.id_na_avtor=i.id_avtor
-where a.ime = 'Goce Smilevski';
+where a.ime like '%Goce Smilevski%';
 }}}
 
 {{{
 select naslov, opis from knigi
-where naslov = 'Мојот маж';
+where naslov like '%Мојот маж%';
 }}}
 
@@ -67 +67 @@
 join e_od as e on e.id_knigi=kn.id_na_kniga
 join kategorija as k on k.id_na_kategorija=e.id_na_kategorija
-where k.ime_kategorija = 'roman';
+where k.ime_kategorija like '%roman%';
 }}}