Hi

Though I'm no expert my initial thought is, that they might not be any difference in the two selects when using an OR where, because SQL would have to check the ID field to see if it's a 1, and no matter if it is or not it would still need to check the title field for the like condition.

Now if it was an AND clause then maybe it might make a difference, especially if you have indexed the ID column but not the title column.

If you have ID=1 AND title LIKE '%text%' then if the first condition returns false then why would SQL need to check the next condition?

I've not tested this so if you do decide to create 1,000,000 rows of data to check the OR condition as suggested, then you might as well check it as an AND to see.

hope this helps.