Jump to content

arief_anang

Members
  • Posts

    4
  • Joined

  • Last visited

Posts posted by arief_anang

  1. 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

    Update

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

  2. 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

×
×
  • Create New...