just out of curiousity, was there a particular advantage to you using
varchar as opposed to date for the column type? because if so it would be
a lot easier to manipulate that date.. you could calculate differences in
dates, get portions of the date, and all sorts of other nice things if it
were a date column...
~shawn
On Thu, 2 Aug 2001, Augusto Cesar Castoldi wrote:
> HelpHi.
>
> I have a colun in my table for the birthday.: "DD/MM/AAAA". It's varchar.
>
> In PHP, I can get the month of date, bu substr($date, 3, 2). (MM)
>
> Can I do a select with %LIKE% but saying the position of the varchar I want to find?
>
> thanks.
>
> Augusto
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
