arief_anang

hi,with php you can use script like this :...$query="Select * from tablename"; $hasil = mysql_query($query); while($barisdata = mysql_fetch_array($hasil)) { print substr_count($barisdata["fieldname"], "wordyoucount"); }...Regards,Anang

Or you can use this script as an altenativeUPDATE tablename SET columnname=CONCAT(00,columnname)orUPDATE tablename SET columnname=00+columnnameRegards,Anang

Perhaps, you can use this script below:SELECT * FROM mytable WHERE postcode=SUBSTRING(postcode,(4-LENGTH(postcode))+1,LENGTH(postcode))Regards,Anang

In my opinion you can use two separate commands.UPDATE ibf_dnames_change SET dname_previous='WizarD1' WHERE dname_previous='WizarD';UPDATE ibf_dnames_change SET dname_previous='zxcvbnm' WHERE dname_previous='coyl';RegardsAnang