Ne govorim ti da menjas podatke, vec da prosledis search string u kom je svaki ' karakter zamenjen sa 2*':
Citat:
01011011:
Code:
select distinct(filename) ,a.imageid, random from images a
inner join ImgAnnotations b on a.imageid = b.imageid
inner join ImgCustomAttrib c on a.imageid = c.masterimageid
inner join imgRandomizer g on c.masterimageid = g.imageid
inner join AnnotKeywords e on a.imageid = e.imageid
where bitDisplayOnWeb = '1' and (e.keyword like '%''%' or a.filename like '%''%')
and (classification ='Rights managed' or classification ='Royalty free' )
order by random
Inace, to ti je nesto sto bi trebalo da predstavlja osnovno znanje!