Welcome To Snipplr


Everyone's Recent MySQL Snippets



1 ... 4 5 6 7 8
1 325 posted 11 years ago by therobot
If the official codex approach (http://codex.wordpress.org/Changing_The_Site_URL) is causing you problems, give this a try. Be sure to change the constant declarations and modify table names as necessary for your instance. Confirmed working with WP v...
1 468 posted 11 years ago by johnandrewsroot
0 372 posted 12 years ago by bradless
1 303 posted 12 years ago by jmacgr
Esquema basico manejo cursores en MYSQL
0 287 posted 12 years ago by xaviles
0 301 posted 12 years ago by level09
1 275 posted 12 years ago by magicrebirth
Some code I found for calculating and determining a persons age
1 269 posted 12 years ago by mpcircuitry
Came across this nice snippet @ mysql.com
2 1320 posted 12 years ago by j4kp07
used to find content that uses the PHP input filter....useful for upgrading core!
0 377 posted 12 years ago by ReeceMarsland
Just updated for WP 3 (added wp_postmeta table for menus)! Test out the new installation thoroughly but everything should be fine, and your CMS should be running live on the new server!
0 309 posted 12 years ago by beneberle
0 393 posted 12 years ago by kingkool68
1 321 posted 12 years ago by nate63179
- fields on db with utf8_general_ci collation - make this query after any connection - put meta charset utf8 - read and write strings without problems
0 326 posted 12 years ago by ginoplusio
Must have a field named Weight. The more Weight the more often the record is selected. Weight should be an integer between 1 and 10.
1 445 posted 12 years ago by BFTrick
MySQL Insert Unique Reference using MAX() to obtain latest value Alternate solution to using Composite Primary Keys which INNODB engine does not support.
0 319 posted 12 years ago by cherbert
1 309 posted 12 years ago by nkm
as a note to self... in order to find it laters... This will only alter the value of fieldname if the conditions in the WHERE clause are met. With replace we only replace a certain string within fieldname with the replace_with string
1 342 posted 12 years ago by iroybot
Remove <>
0 388 posted 12 years ago by jodm
It's not 100% accurate, but works fine for people under 1.480.
2 493 posted 12 years ago by nkm
1 ... 4 5 6 7 8