update dbo.VolnaMista set
	OborId = 1
	where lower(ProfeseNazev) like '%matemat%'
	and OborId is null

update dbo.VolnaMista set
	OborId = 2
	where lower(ProfeseNazev) like '%geo%'

update dbo.VolnaMista set
	OborId = 3
	where lower(ProfeseNazev) like '%karto%'

update dbo.VolnaMista set
	OborId = 4
	where lower(ProfeseNazev) like '%chem%'

update dbo.VolnaMista set
	OborId = 5
	where lower(ProfeseNazev) like '%biolo%'