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. Unknown column in ‘field list’ error on MySQL Update query
  8. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  9. What’s the difference between VARCHAR and CHAR?
  10. Cannot delete or update a parent row: a foreign key constraint fails
  11. Rename a column in MySQL
  12. Column name or number of supplied values does not match table definition
  13. Simple PHP Pagination script
  14. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  15. ORA-12560: TNS:protocol adaptor error
  16. Operand type clash: int is incompatible with date + The INSERT statement conflicted with the FOREIGN KEY constraint
  17. difference between primary key and unique key
  18. How to SUM two fields within an SQL query
  19. DateTime2 vs DateTime in SQL Server
  20. Difference between numeric, float and decimal in SQL Server
  21. CREATE TABLE IF NOT EXISTS equivalent in SQL Server
  22. How can I do ‘insert if not exists’ in MySQL?
  23. String or binary data would be truncated. The statement has been terminated
  24. Error converting data type varchar to float
  25. How to concatenate text from multiple rows into a single text string in SQL Server
  26. Count(*) vs Count(1) – SQL Server
  27. Remove duplicate rows in MySQL
  28. “You tried to execute a query that does not include the specified aggregate function”
  29. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  30. How to round down to nearest integer in MySQL?
  31. mysql update column with value from another table
  32. SQL: IF clause within WHERE clause
  33. ‘NOT LIKE’ in an SQL query
  34. SQL Server dynamic PIVOT query?
  35. How to get the count of each distinct value in a column?
  36. What is tableName.* in SQL
  37. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  38. $wpdb->get_results(…) returns empty array despite correct query
  39. Get Post ID by Content
  40. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  41. Sharing database for collaborative development
  42. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  43. How to display multiple Post meta_key/meta_values by SQL query
  44. Inserting Post Meta From SQL
  45. Get WooCommerce product attribute taxonomies in a SQL query on WordPress database
  46. Advanced WP Query hogs the SQL server
  47. How to Move Local Singlesite Database to Remote Multsite Database?
  48. Export entries and multiple custom field meta to .csv?
  49. Uppercase to sentence case for post titles
  50. SQL query to retrieve all the records that have not indicated category
  51. Sorting events by descending date, and ascending time if multiple events on a date
  52. How do I see the mysql query generated by get_posts( $args )?
  53. WordPress Database Huge wp_usermeta Table
  54. Remove posts inside pre_get_posts using a custom query
  55. Genesis framework comments broken?
  56. Databases – Submitting data from inputs to database [closed]
  57. Get posts under a category with SQL
  58. Get all child comments ids from parent comment id
  59. Making a query to the DB using same parameters of loop
  60. SQL command to convert all tags in lowercase?
  61. Insert Query not working in the form
  62. Is it best to avoid using $wpdb for security issues?
  63. pull data from a remote wordpress database
  64. SQL query to return categories and category parents
  65. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  66. SQL Bulk update all WordPress user’s nicknames to firstname + lastname format
  67. Correct PHP to output a single result of a Function with SQL Query
  68. How can I add a new row in a separate database when someone registers via WordPress?
  69. Why does changing Database Table Prefixes result in loss of content?
  70. Query where ANDing slug values not working
  71. Options on how to Display member specific data from a MS SQL database
  72. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  73. wordpress site – using custom database and PHP
  74. Use variable in SQL statement
  75. WordPress wpdb->insert returns int(0) => doesn’t insert anything, no errors!
  76. WordPress SQL – How to Check for Category?
  77. SQL Bulk Move old posts by one author to another category
  78. Fetching review value using wpdb class
  79. Change word in woocommerce product category custom field
  80. I want to get on those users their meta value are like “AGENT” .. but this query is not working
  81. Woocommerce change the price of products in the database
  82. A query to substitute images paths in gutenberg (website migration)?
  83. SQL query: select duplicate posts – but using duplicate meta [duplicate]
  84. searching by keywords in post’s metas or pagination links problem
  85. Inserting other fields to existing registration form in a WordPress theme
  86. Organising and completing posts (mark as read and hide)
  87. Are there any best practices for creating a Like/Favourite feature in WordPress using custom MySQL tables and without any plugins?
  88. What argument does my function need to echo get_results() query results
  89. How i make a custom sql query for Woocommerce
  90. Sum of Custom Meta written by Authour
  91. Alter the main search query to search posts by coauthor user name
  92. Query to get data of a post, if in category?
  93. Wpdb generates too many queries
  94. Install WordPress with SQL database
  95. Replace Unwanted Space in Post Content URL
  96. If meta_key exists then don’t select this post?
  97. Custom Query for wp_posts using wp_postmeta
  98. Merge meta_value’s into a single row and then loop
  99. How to sort search result by post_title, then by post_content
  100. Possible SQL injection. How to locate and fix?

Leave a Comment