X
wpwpadmin

Update MySQL where id in range and use md5

In MySQL sometimes we need to update a set of rows within the specific range of ids. If the range is short then we can use the ID IN (ids) argument. If it's long and we know that range, let's use the BETWEEN value AND value argument.

UPDATE `table` SET `password` = (SELECT MD5(uniqueName)) WHERE `id` BETWEEN 863 AND 987

Categories: Articles
wpwpadmin:
Related Post
  1. Warning: exec() has been disabled for security reasons

    Function exec is disabled. What to do? I see the "Warning: exec() has been disabled…

  2. Drupal requirements

    by Alex Benko, 2by2host Drupal requirements for the installation The minimum disk space needed for…

  3. How we back up all sites

    According to our rules the customers are fully responsible for backing up their websites and…