Use ‘=’ or LIKE to compare strings in SQL?

by

LIKE and the equality operator have different purposes, they don’t do the same thing:
= is much faster, whereas LIKE can interpret wildcards. Use = wherever you can and LIKE wherever you must.

SELECT * FROM user WHERE login LIKE 'Test%';

Sample matches:

TestUser1
TestUser2
TestU
Test

More Related Contents:

  1. Why would an IN condition be slower than “=” in sql?
  2. Get Parent with multiple children in desc order
  3. How can I schedule a job to run a SQL query daily?
  4. Convert Month Number to Month Name Function in SQL
  5. How to avoid the “divide by zero” error in SQL?
  6. How do I do top 1 in Oracle? [duplicate]
  7. Multiple INSERT statements vs. single INSERT with multiple VALUES
  8. Removing leading zeroes from a field in a SQL statement
  9. Database Structure for Tree Data Structure [closed]
  10. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  11. sql ORDER BY multiple values in specific order?
  12. MySQL’s now() +1 day
  13. Oracle SQL – Identify sequential value ranges
  14. ColdFusion adding extra quotes when constructing database queries in strings
  15. NOT NULL constraint over a set of columns
  16. In SQL, is UPDATE always faster than DELETE+INSERT?
  17. How can I determine the status of a job?
  18. MySQL #1140 – Mixing of GROUP columns
  19. How can I select rows with most recent timestamp for each key value?
  20. How to delete the top 1000 rows from a table using Sql Server 2008?
  21. SQL Error: ORA-00942 table or view does not exist
  22. CHECK CONSTRAINT on multiple columns
  23. Query for getting value from another record in same table and filter by difference greater than a gap threshold
  24. What are the use cases for selecting CHAR over VARCHAR in SQL?
  25. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  26. How to extract week number in sql
  27. Why do multiple-table joins produce duplicate rows?
  28. How do I format date and time on ssrs report?
  29. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  30. Insert into from CTE

Leave a Comment