RE: Date()
Look at the DATE_FORMAT function. http://www.mysql.com/doc/en/Date_and_time_functions.html -Original Message- From: hotel [mailto:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 6:07 PM To: mySQL Subject: Date() Is it possible for mySQL to recognize and compare dates written in this format: MM/DD/YY? I know standard date format for mySQL is YYY-MM-DD, but I need to be able to support this other format if possible. For example, I have a string of 01/30/02 and I just need to compare it to another value already in the dB, being held as a varchar with a value of 02/28/02. I need to compare these to determine if one date preceeds the other. Any way of doing this with the resources mySQL already has built in - without having to convert the format of the date values? Thanks. Neal - 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 - 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
FULLTEXT search against a query result
Okay, here we go ...
I would like to do a FULLTEXT search against a query result. There are
multiple columns that have a FULLTEXT index. Hopefully I break this
down in a manner that can be understood.
The fields of interest:
Table events:
event_id [int(11)]
event [varchar(255)]
description [text]
FULLTEXT (event, description)
Table event_times:
event_id [int(11)] from events.event_id
start_date [date]
place [varchar(255)]
FULLTEXT (place)
I would like to search the fields events.event, events.description, and
event_times.place. So hypothetically it would look something like
MATCH(events.event, events.description, event_times.place)
AGAINST('keywords').
The results I need to use for the search is produced from the query:
SELECT events.category_id, events.event_id, events.event,
events.description, event_times.start_date, chc_event_times.place
FROM events INNER JOIN event_times ON events.event_id =
event_times.event_id
GROUP BY events.event_id
If this makes no sense to you or if you need more information, please
let me know.
Thanks for your time.
Jay Douglas
Systems Consultant
Fort Collins, CO
-
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
