arief_anang
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by arief_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
Counting word occurences
in SQL
Posted
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