finding exact strings with sql like statement

Question

I have the following statement

SELECT *
FROM   Delivery_Note this_
WHERE  mycol like '%[126]%'

I've noticed this also returns rows that contain [123]. What is the best way to find exact matching in a string.

edit I appreciate this is not an efficient query. There a few other reasons for this approach.

Aaron Bertrand · Accepted Answer · 2012-08-15 14:45:22Z

2

Brackets specify a range when used with LIKE. You can use the ESCAPE keyword.

WHERE mycol LIKE '%\[126\]%' ESCAPE '\';

Of course if you are trying to match an exact string, you don't need LIKE, or you can drop the % characters and LIKE will behave like = (this makes it flexible to pass in wildcards or exact matches to a parameter).

answered Aug 15, 2012 at 14:45

Aaron Bertrand

282k37 gold badges469 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

finding exact strings with sql like statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related