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

To see the performance difference, try this:

SELECT count(*)
FROM master..sysobjects as A
JOIN tempdb..sysobjects as B
on A.name = B.name

SELECT count(*)
FROM master..sysobjects as A
JOIN tempdb..sysobjects as B
on A.name LIKE B.name

Comparing strings with ‘=’ is much faster.

Related Posts:

  1. Compare dates in MySQL
  2. Comparing chars in Java
  3. How is __eq__ handled in Python and in what order?
  4. Value for epsilon in Python
  5. Comparison operator
  6. Want to make a web page that should work like [closed]
  7. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  8. What’s the best way to search for a UPC code in a Database?
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  11. What is the difference between “INNER JOIN” and “OUTER JOIN”?
  12. What is the difference between UNION and UNION ALL?
  13. Selecting COUNT(*) with DISTINCT
  14. Case in Select Statement
  15. What is a stored procedure?
  16. ORA-00904: invalid identifier
  17. SQL WITH clause example [duplicate]
  18. What is an index in SQL?
  19. Inserting multiple rows in a single SQL query? [duplicate]
  20. Unknown column in ‘field list’ error on MySQL Update query
  21. Unknown column in ‘field list’ error on MySQL Update query
  22. SQL Inner-join with 3 tables?
  23. The wait operation timed out. ASP
  24. What is SELF JOIN and when would you use it? [duplicate]
  25. The wait operation timed out. ASP
  26. Conversion failed when converting date and/or time from character string while inserting datetime
  27. Self Join to get employee manager name
  28. How do I UPDATE from a SELECT in SQL Server?
  29. SQL error “ORA-01722: invalid number”
  30. how to fix oracle ORA-01722 invalid number error
  31. SQL query to select dates between two dates
  32. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  33. MySQL – Operand should contain 1 column(s)
  34. SQL SELECT WHERE field contains words
  35. Conversion failed when converting date and/or time from character string while inserting datetime
  36. When should I use CROSS APPLY over INNER JOIN?
  37. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  38. Understanding cmp instruction
  39. Insert Data Into Temp Table with Query
  40. QL Error: ORA-00933: SQL command not properly ended
  41. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  42. SQL query to get the employee name and their manager name from the same table
  43. MySQL create table if not exists and insert record only if table was created
  44. error, string or binary data would be truncated when trying to insert
  45. Sort array of objects by string property value
  46. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  47. NOT IN vs NOT EXISTS
  48. SQL SELECT WHERE field contains words
  49. Online SQL Query Syntax Checker
  50. How can I do an UPDATE statement with JOIN in SQL Server?
  51. Must declare the scalar variable
  52. ORA-00979 not a group by expression
  53. T-SQL split string
  54. ORA-00907: missing right parenthesis
  55. How do I use properly CASE..WHEN in MySQL
  56. Must declare the scalar variable
  57. What is “Advanced” SQL?
  58. Rename column SQL Server 2008
  59. Why do we need “Relationships” between tables at all?
  60. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  61. Using group by on multiple columns
  62. Efficiently convert rows to columns in sql server
  63. Optimum way to compare strings in JavaScript?
  64. How to turn IDENTITY_INSERT on and off using SQL Server 2008?sql-server-2008
  65. How to delete duplicate rows in SQL Server?
  66. The SQL OVER() clause – when and why is it useful?
  67. Update multiple columns in SQL
  68. How can I do a FULL OUTER JOIN in MySQL?
  69. Nested select statement in SQL Server
  70. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  71. Using group by on multiple columns
  72. SQL SELECT WHERE field contains words
  73. SQL Query with NOT LIKE IN
  74. MySQL query String contains
  75. How do I escape a single quote in SQL Server?
  76. What’s the difference between VARCHAR and CHAR?
  77. Cannot delete or update a parent row: a foreign key constraint fails
  78. Cannot delete or update a parent row: a foreign key constraint fails
  79. SQL Server IF EXISTS THEN 1 ELSE 2
  80. Case statement in MySQL
  81. How to update multiple columns in single update statement in DB2
  82. Rename a column in MySQL
  83. T-SQL split string based on delimiter
  84. How to declare a variable in MySQL?
  85. How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
  86. Finding duplicate values in a SQL table
  87. ORA-01843 not a valid month- Comparing Dates
  88. Cannot delete or update a parent row: a foreign key constraint fails
  89. SQL Query with SUM with Group By
  90. MySQL Cannot Add Foreign Key Constraint
  91. How do I restore a dump file from mysqldump?
  92. Drop a temporary table if it exists
  93. How do I perform an IF…THEN in an SQL SELECT?
  94. How do I escape a single quote in SQL Server?
  95. SQL Error: ORA-00942 table or view does not exist
  96. ORA-00918: column ambiguously defined in SELECT *
  97. Teradata: how to convert varchar value (format ‘dd.mm.yyyy’) to date (format ‘yyyy-mm-dd’ )?
  98. How Stuff and ‘For Xml Path’ work in SQL Server?
  99. Data source name not found, and no default driver specified
  100. IDENTITY_INSERT is set to OFF – How to turn it ON?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)