SELECT name FROM greetings WHERE upper(greeting) like '%HELLO%';
- SELECT name FROM greetings
WHERE greeting='Hello';- WHERE upper(greeting) like '%HELLO%';
results = run_sql describe :items do it "should return 10 items" do expect(results.count).to eq 10 end end
- results = run_sql
- describe :items do
it "should return 7 items" doexpect(results.count).to eq 7- it "should return 10 items" do
- expect(results.count).to eq 10
- end
- end