I'm using the SQL query box in phpMyAdmin (MyISAM). Below works fine unless I try updating more than one row at a time. Can someone tell me what I'm doing wrong?
UPDATE table_name SET column_name = 'Air' WHERE row_name = 's003';
If I try adding say 'tr003, s005'; -- that won't work. I get message "0 rows affected". I have searched but couldn't find help for this. Thank you.
You can use an
IN clause for this:
UPDATE table_name SET column_name = 'Air' WHERE row_name in ('s003', 'tr003', 's005');