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

• Big /
• Small

Top Users

•  chrisaiv (285)
•  jerryvig (264)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  ljayz (185)
•  adrianparr (180)
•  1man (166)
•  Scooter (158)

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. Load CSV back into mySQL

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

7. Drupal 6.x Find PHP code in database

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

8. Generate random string in MySQL

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

9. Calculate Age from Date Of Birth

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

10. Find & Replace

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

11. Select between two dates

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

12. how to calculate last 7 days...

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

13. US & CANADA Cities Database

    MySQL mysql database states sql list usa city United canada cities saved by 4 people
    posted on October 22, 2011 by frederichoule

14. mysql dump

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

15. Mysql replace

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

16. Convert timezone to local

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

17. Search and Replace on Multiple Rows in SQL

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

18. multiple insert with one query

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

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

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

20. 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

21. mySQL - database backup commands

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

22. Backup MySQL Database to SQL File with mysqldump

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

23. MySql import

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

24. find duplicate records

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

25. MySQL Find and Replace

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

26. How to Back Up and Restore a MySQL Database

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

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 values that occur exactly once in table

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

34. MySql script to find invalid email addresses

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

35. MySQL Age Calucation

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

36. Date formatting with LOAD DATA INFILE

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

37. Left Joins to link three or more tables

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

38. MySQL REGEX match comma-delimitted list

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

39. Get random record based on weight

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

40. mysqli Prepared Statements

    MySQL saved by 3 people
    posted on September 24, 2009 by KF