n00b question. Got a products table set up by a shopping cart script. The two columns are pID and pExemptions. Need to update all the pExemptions with the number 4 in records that match the pID starting with the first three characters "MP3." How could I use phpMyAdmin for this?

sample rows, please

wite an update query

update mytable set mycolumn = 4 where mycolumn2 like "MP3%"

thanks! worked great