• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Top Users

•  chrisaiv (325)
•  jerryvig (265)
•  ljayz (220)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  adrianparr (180)
•  1man (169)
•  Scooter (159)

Popular Tags

Popular MySQL Snippets

• All time
•  / week
•  / month
•  / year

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. MySQL Find and Replace

   MySQL mysql path replace find saved by 10 people
   posted on February 25, 2010 by Jamie

2. Selecting a Random Row In MySQL

   MySQL saved by 7 people
   posted on January 21, 2009 by jordantbro

3. Create CSV from MySQL

   MySQL mysql saved by 6 people
   posted on September 17, 2010 by matula

4. Find duplicate records

   MySQL mysql deduplication saved by 6 people
   posted on May 5, 2010 by fugue

5. Correcting 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. US & 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. Load CSV back into mySQL

   MySQL mysql saved by 5 people
   posted on September 17, 2010 by matula

8. Drupal 6.x Find PHP code in database

   MySQL mysql php drupal saved by 5 people
   posted on December 4, 2009 by ReeceMarsland

9. Generate random string in MySQL

   MySQL login mysql random saved by 5 people
   posted on November 10, 2009 by fugue

10. Calculate Age from Date Of Birth

    MySQL date calculate birth dob saved by 5 people
    posted on August 29, 2009 by nkm

11. Find & Replace

    MySQL url replace find saved by 5 people
    posted on May 16, 2009 by randyjhunt

12. Select between two dates

    MySQL mysql date between saved by 5 people
    posted on April 26, 2009 by craig1709

13. Backup MySQL Database to SQL File with mysqldump

    MySQL mysqldump saved by 5 people
    posted on April 10, 2009 by cbrant

14. how to calculate last 7 days...

    MySQL date saved by 5 people
    posted on January 8, 2009 by

15. How to Back Up and Restore a MySQL Database

    MySQL mysql backup saved by 4 people
    posted on December 15, 2010 by sergeygerasimov

16. mysql dump

    MySQL saved by 4 people
    posted on December 1, 2010 by elguapo1611

17. Mysql replace

    MySQL saved by 4 people
    posted on October 14, 2010 by mikael12

18. Convert timezone to local

    MySQL time date timezone saved by 4 people
    posted on March 10, 2010 by fugue

19. Search and Replace on Multiple Rows in SQL

    MySQL saved by 4 people
    posted on February 25, 2010 by Tate

20. multiple insert with one query

    MySQL saved by 4 people
    posted on January 20, 2010 by renaars

21. How to Save results from MySQL into an external file

    MySQL mysql saved by 4 people
    posted on December 18, 2009 by endorfin

22. Insert 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. mySQL - database backup commands

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

24. MySql import

    MySQL mysql saved by 4 people
    posted on April 10, 2009 by glends

25. find duplicate records

    MySQL saved by 3 people
    posted on April 23, 2011 by wirenaught

26. MySQL Find and Replace

    MySQL mysql saved by 3 people
    posted on March 2, 2011 by nielsenrc

27. Add Wordpress admin user to database

    MySQL mysql wordpress user admin WP3 saved by 3 people
    posted on October 9, 2010 by timkinnane

28. Display MYSQL date as readable to us humans

    MySQL mysql php date saved by 3 people
    posted on September 8, 2010 by flashmac

29. MySQL Country Table With Abbreviations and Names

    MySQL saved by 3 people
    posted on July 6, 2010 by aeboi80

30. State/Province For: United States, Canada, and UK

    MySQL stateprovinceuscanadauk saved by 3 people
    posted on July 6, 2010 by aeboi80

31. Change Drupal file directory path

    MySQL drupal saved by 3 people
    posted on May 24, 2010 by zachharkey

32. MySQL - Most relevant weighted results based (MATCH AGAINST)

    MySQL mysql sql saved by 3 people
    posted on April 27, 2010 by LuckyShot

33. Find all tables in MySQL database containing specific column names

    MySQL saved by 3 people
    posted on February 22, 2010 by lancemonotone

34. Find values that occur exactly once in table

    MySQL mysql saved by 3 people
    posted on February 20, 2010 by atma

35. MySql script to find invalid email addresses

    MySQL email find addresses invalid saved by 3 people
    posted on January 29, 2010 by fackz

36. MySQL Age Calucation

    MySQL mysql db saved by 3 people
    posted on December 12, 2009 by mpcircuitry

37. Date formatting with LOAD DATA INFILE

    MySQL mysql data import csv infile saved by 3 people
    posted on December 10, 2009 by j4kp07

38. Left Joins to link three or more tables

    MySQL saved by 3 people
    posted on December 3, 2009 by karmacode

39. MySQL REGEX match comma-delimitted list

    MySQL regex mysql csv saved by 3 people
    posted on November 2, 2009 by j4kp07

40. Get random record based on weight

    MySQL mysql random query record weight weighted saved by 3 people
    posted on September 30, 2009 by BFTrick