Issue with WP-CLI search-replace and MySQL query

[ad_1]

I’m currently using search-replace in WP-CLI to switch over an old domain to a new one. When running the following command in WP-CLI, it shows over 4,000 results in the wp_options table:

wp search-replace ‘old URL’ ‘new URL’ —skip-columns=guid —dry-run

However when trying to search for this in MySQL with the same URL it shows over 6,000 results:

SELECT*FROM ‘wp_options’ WHERE option_value like ‘old URL’

Is there a reason why it would show two different results and not show the same ones?

[ad_2]