Latest 5

UMaine Studbook Collection
Posted: 2018-10-14 06:34:38
Club Francais Korthals N79 1975
Posted: 2018-01-27 04:36:49
Invisible Google Captcha
Posted: 2017-11-10 12:51:42
Font Awesome
Posted: 2017-10-25 01:25:14

Top 5

AKC 1890
Posted: 2015-10-16 15:29:12 (2393 Reads)
Norwegian Kennel Club Database
Posted: 2015-10-22 10:36:06 (2295 Reads)
AKC 1895
Posted: 2015-10-22 11:38:43 (2286 Reads)
LOSH (Belgium) Scans Available
Posted: 2017-04-29 19:47:07 (2039 Reads)

Join our Newsletter

to get informed about new blog entries!
We care about your privacy - we do not send our Newsletters to all registered users, only if you subscribe HERE!
* indicates required
Choose your Category/Categories


Ask for becoming a member of the closed group: Dog Pedigree Databases/Research

The Pedigree Cloud - SQL

All Tags
Google Charts & Tables

Present your data in a beautiful way with Google Charts - no additional software needed, just a little bit of code writing...

SELECT CURDATE();   2017-08-31
With DATE_FORMAT() you can choose the way the date and/or time is shown in mySQL - some examples here, the complete list is shown below:

like and not like in php

Building an if statement in php with 'like' or 'not like' as an operator, the syntax is different to the on in SQL.

Backup your database

I hope that you all backup your databases regularly, and with regularly I mean at least once a day. Those data are too valuable to get lost.
I have been using MySQLDumper for years, a PHP and Perl based tool for backing up MySQL databases and I really loved it. Now with PHP 7 it stopped working properly and the developer decided to stop the work on that project.
So not wanting to make a dump every day manually from the phpAdmin surface, I wrote a php file which runs as a cronjob on my server.
Feel free to use and/or modify the code!

SQL Capitalize String

Do you have members who enter the dog's or person's name in Capitals?
Here is a code that works to make the first letters of each word uppercase.
Annabelle Miss of Settercity

SQL Update Part of a String

You want to update a part of a string in SQL, e.g. you want to change all registry numbers that include "N.H.S.B." to "NHSB"

SQL Update Column

You want to update a complete column in SQL, e.g. you want to change the country code for Great Britain from "GB" to"UK"


The TRIM function is used to remove a defined prefix or suffix from a string. If nothing is specified, white spaces are removed.

Render time: 0.11 seconds
396,343 unique visits