I am new to sql and trying to update a bunch of records , i tried selecting them all, and they came fine when i used the wildcards, but now when i run the following command, it returns, 0 rows affected.
UPDATE wp_comments
SET comment_author_url= '/wp-content/themes/abc/images/new.png'
WHERE comment_author_url= '/gender/%'
am i missing something, or the wildcards doesn’t work with update?