Use '=' or LIKE to compare strings in SQL?

Posted by furtelwart on Stack Overflow See other posts from Stack Overflow or by furtelwart
Published on 2009-02-05T08:35:04Z Indexed on 2010/04/24 1:53 UTC
Read the original article Hit count: 311

Filed under:
|
|

Hi!

There's the (almost religious) discussion, if you should use LIKE or '=' to compare strings in SQL statements.

  • Are there reasons to use LIKE?
  • Are there reasons to use '='?
  • Performance? Readability?

Thanks in advance!

© Stack Overflow or respective owner

Related posts about sql

Related posts about best-practices