In order to generate some useful test data
eg randomnly setting the flag select_normal to 0 or 1 use the following
update tbl_products set select_normal=round(rand());
I've actually answered my own question (as usual in formulating the question you often can
But anyone got any other useful queries in this line?
vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?"
http://www.rayninfo.co.uk/tips/ vim, zsh & success tips
|• Update query to set random data||zzapper||1 Jul|