Popular MySQL Snippets




« Prev [Page 1 of 5] Next »
  1. FAVMySQL Find and Replace

    MySQL mysql path replace find saved by 10 people
    posted on February 25, 2010 by Jamie
  2. FAVSelecting a Random Row In MySQL

    MySQL saved by 7 people
    posted on January 21, 2009 by jordantbro
  3. FAVCreate CSV from MySQL

    MySQL mysql saved by 6 people
    posted on September 17, 2010 by matula
  4. FAVFind duplicate records

    MySQL mysql deduplication saved by 6 people
    posted on May 5, 2010 by fugue
  5. FAVCorrecting wrong character encoding in MySQL data

    MySQL mysql character utf8 convert encoding latin1 saved by 6 people
    posted on March 6, 2009 by jdbartlett
  6. FAVUS & CANADA Cities Database

    MySQL mysql database states sql list usa city United canada cities saved by 5 people
    posted on October 22, 2011 by frederichoule
  7. FAVLoad CSV back into mySQL

    MySQL mysql saved by 5 people
    posted on September 17, 2010 by matula
  8. FAVDrupal 6.x Find PHP code in database

    MySQL mysql php drupal saved by 5 people
    posted on December 4, 2009 by ReeceMarsland
  9. FAVGenerate random string in MySQL

    MySQL login mysql random saved by 5 people
    posted on November 10, 2009 by fugue
  10. FAVCalculate Age from Date Of Birth

    MySQL date calculate birth dob saved by 5 people
    posted on August 29, 2009 by nkm
  11. FAVFind & Replace

    MySQL url replace find saved by 5 people
    posted on May 16, 2009 by randyjhunt
  12. FAVSelect between two dates

    MySQL mysql date between saved by 5 people
    posted on April 26, 2009 by craig1709
  13. FAVBackup MySQL Database to SQL File with mysqldump

    MySQL mysqldump saved by 5 people
    posted on April 10, 2009 by cbrant
  14. FAVhow to calculate last 7 days...

    MySQL date saved by 5 people
    posted on January 8, 2009 by
  15. FAVHow to Back Up and Restore a MySQL Database

    MySQL mysql backup saved by 4 people
    posted on December 15, 2010 by sergeygerasimov
  16. FAVmysql dump

    MySQL saved by 4 people
    posted on December 1, 2010 by elguapo1611
  17. FAVMysql replace

    MySQL saved by 4 people
    posted on October 14, 2010 by mikael12
  18. FAVConvert timezone to local

    MySQL time date timezone saved by 4 people
    posted on March 10, 2010 by fugue
  19. FAVSearch and Replace on Multiple Rows in SQL

    MySQL saved by 4 people
    posted on February 25, 2010 by Tate
  20. FAVmultiple insert with one query

    MySQL saved by 4 people
    posted on January 20, 2010 by renaars
  21. FAVHow to Save results from MySQL into an external file

    MySQL mysql saved by 4 people
    posted on December 18, 2009 by endorfin
  22. FAVInsert or update if unique key already exist

    MySQL insert key unique duplicate update saved by 4 people
    posted on October 27, 2009 by Zwendel
  23. FAVmySQL - database backup commands

    MySQL mysql database db command backup cli saved by 4 people
    posted on June 7, 2009 by stiobhart
  24. FAVMySql import

    MySQL mysql saved by 4 people
    posted on April 10, 2009 by glends
  25. FAVfind duplicate records

    MySQL saved by 3 people
    posted on April 23, 2011 by wirenaught
  26. FAVMySQL Find and Replace

    MySQL mysql saved by 3 people
    posted on March 2, 2011 by nielsenrc
  27. FAVAdd Wordpress admin user to database

    MySQL mysql wordpress user admin WP3 saved by 3 people
    posted on October 9, 2010 by timkinnane
  28. FAVDisplay MYSQL date as readable to us humans

    MySQL mysql php date saved by 3 people
    posted on September 8, 2010 by flashmac
  29. FAVMySQL Country Table With Abbreviations and Names

    MySQL saved by 3 people
    posted on July 6, 2010 by aeboi80
  30. FAVState/Province For: United States, Canada, and UK

    MySQL stateprovinceuscanadauk saved by 3 people
    posted on July 6, 2010 by aeboi80
  31. FAVChange Drupal file directory path

    MySQL drupal saved by 3 people
    posted on May 24, 2010 by zachharkey
  32. FAVMySQL - Most relevant weighted results based (MATCH AGAINST)

    MySQL mysql sql saved by 3 people
    posted on April 27, 2010 by LuckyShot
  33. FAVFind all tables in MySQL database containing specific column names

    MySQL saved by 3 people
    posted on February 22, 2010 by lancemonotone
  34. FAVFind values that occur exactly once in table

    MySQL mysql saved by 3 people
    posted on February 20, 2010 by atma
  35. FAVMySql script to find invalid email addresses

    MySQL email find addresses invalid saved by 3 people
    posted on January 29, 2010 by fackz
  36. FAVMySQL Age Calucation

    MySQL mysql db saved by 3 people
    posted on December 12, 2009 by mpcircuitry
  37. FAVDate formatting with LOAD DATA INFILE

    MySQL mysql data import csv infile saved by 3 people
    posted on December 10, 2009 by j4kp07
  38. FAVLeft Joins to link three or more tables

    MySQL saved by 3 people
    posted on December 3, 2009 by karmacode
  39. FAVMySQL REGEX match comma-delimitted list

    MySQL regex mysql csv saved by 3 people
    posted on November 2, 2009 by j4kp07
  40. FAVGet random record based on weight

    MySQL mysql random query record weight weighted saved by 3 people
    posted on September 30, 2009 by BFTrick
« Prev [Page 1 of 5] Next »