Little sql question

[Slowpoke]

Is there any way to reduce the cost of all buildings EXCEPT wonders in an easy way? Or do I have to specify every individual wonder.

 

[smellymummy]

haven't tried yet but if you can do subqueries, shouldnt be a problem

edit: ok so i tried it and couldn't do it with the sql lite browser addon

but this works:

select type, cost from buildings where civilopedia not like "%WONDER%"

assuming all wonders have the string WONDER in their civilopedia entry. you could also use a where clause on