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
If you would like a service but do not have enough of a budget, earn points through our affiliate program by referring customers to us and use them toward your project or service with us.
Have any questions?
Use the following form to submit them or call us at 917.558.8139 within US or +1 917 558 81 39 (International).
GEORGE
Sales & marketing
ALEX
Sales & marketing
GREG
Senior developer
Use the form below and ask your questions
Fields with asterisk are required