SQL question

[Trond Hoyem]

LIKE "something" is an exact match but not case-sensitive. LIKE "%something%" is a partial match which looks for values that contain "something".

OK, but still I do not see it.
If I use the code 

Code:

elementer = db:getall('SELECT name FROM visobjects WHERE floor LIKE ? AND type NOT LIKE ?', origID, 6)

I will get a result. In this I am also looking for objec(s) containing "something", am I not? The values in the variables in my first post are the same in both examples.