Properly use Underscores with LIKE in a WHERE Clause

Underscores signify a single character in SQL language. Using LIKE for underscores will returns all values for ‘x’ whether they contain an underscore or not. Therefore, usage as shown below will not give the desired result:

Select x from MyTable where x like ‘%_%’

The correct usage is to use brackets, like ‘%[_]%’ as shown below:

Select x from MyTable where x like ‘%[_]%’

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: