Sometimes we need find and replace string/text in mysql tables. Here is the sql i use and find works
UPDATE mysql_table_name SET mysql_column_nam= REPLACE(mysql_column_name, ‘string_to_find’, ‘string_to_replace’);
Category: MySQL
We use phpmyadmin many times and in structure tab, we see the table
This overhead in phpmyadmin reports in tables, is when you have deleted large chuncks from an myisam table. The myisam row get a bit shorter, creating space in the table/datafile which is used next time there will be an insert/etc (handy for speed and performance). This is not really a problem, and you can easily ‘fix’ this by doing an optimize on the table.
run sql command if Table_name is our mysql table
optimize table Table_name
or simply use phpmyadmin, select the table and at bottom of the With Selected Dropdown select Optimize table, and it will minimize your table size… 
Pligg is an open source Content Management System (CMS) available to download for free. Pligg has perfected content management in a unique way that encourages users to participate and control the content on the site. This makes the site user-moderated and allows for “social publishing” where the stories are created and promoted by members not website editors. Pligg CMS is based on PHP and MySQL technologies that allow it to be installed on almost any web host on a relatively small budget. For support please visit the Pligg Forum where you can find help 24 hours a
day thanks to our excellent development team and contributors. Pligg is free software, but you are welcome
to donate any amount by clicking the button below.
WordPress Coding Standards
Some legacy parts of the WordPress code structure for PHP markup are inconsistent in their style. WordPress is working to gradually improve this by helping users maintain a consistent style so the code can remain clean and easy to read at a glance.
View full article »
 |
Certified Professionals. Verified Work. |
oDesk My Office/Heaven
Hi,
I work at oDesk…you see i got a heaven at earth? 
don’t you believe me..???? ok just signup and test oDesk …i swear if you have little patient and if you interested to earn from home…test heaven happyness then .:) believe me…signup and start apply oDesk job. Give oDesk tests to increase your job quota.
Ohh You want to post a job….No worry…you come at right place …oDesk is the best place where you can get the planet best service from a 10000000000million talents at this planet…you confuse????Oh ok man just go to odesk and post a job….and dont forgot to email me…if i am right…
Oh…you want to hire me…all right …just click me
I would like you see at odesk soon….
Thanks
shahin
shahinbdboy@gmail/yahoo.com
http://www.creatiu.com/tennis/tennis.php?language=en
play and save your name and score….
Action script with php work… for creatiu project
I do work on php for many years, i use codeigniter,ajax,mysql,Pligg,wordpress,smarty,zend FW etc.
ucanhireme
