RE: Date()

2002-11-29 Thread Jay \(MySQL List\)
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

FULLTEXT search against a query result

2002-11-28 Thread Jay \(MySQL List\)
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