Browse 531 attributed reviews, viewable separately for our classroom and online training

Details for eric

eric has participated in the following threads:

Added by Kareem44 on 07 Sep 2017 at 10:03

cannot solve it

select EventName, EventDetails, EventDate from tblEvent where  (CountryID = 8 or CountryID = 22 or CountryID = 30 or CountryID = 35) or EventDetails = '%water%' or CategoryID = 4 and year(EventDate) >= 1970

Added by eric on 05 Nov 2017 at 07:51

1st query should not return 4 rows but 1

select * from tblEvent
where EventDetails like '% train %' and CategoryID != 14

i guess your query is:

EventDetails like '%train%'          

which is incorrect as it will return words such as training...etc