Posted by Toby A Inkster on 08/03/07 17:11

bill wrote:

> Q1: Why the WHERE tempcol LIKE '%/%/%' clause ?
> It would seem that it would work without it.
> Q2: Why 3 %'s ?

A1: "WHERE tempcol LIKE '%/%/%'" means "where tempcol has the format
something-slash-something-slash-something". In other words, when tempcol
looks a bit like it could be a date.

A2: A date has three components: day, month and year.

--
Toby A Inkster BSc (Hons) ARCS
[Geek of HTML/SQL/Perl/PHP/Python/Apache/Linux]
[OS: Linux 2.6.12-12mdksmp, up 43 days, 20:49.]

Command Line Interfaces, Again
http://tobyinkster.co.uk/blog/2007/08/02/command-line-again/

• Next in forum: Re: NTP - Time Synch?
• Prev in forum: Re: Importing MS Access into MySQL on Mac?
• Thread view: Re: Text field as date (MySQL)

[Reply to this message]