SELECT * FROM table_name WHERE EndDate < now();
Is this what you need?
-Original Message-
From: Rob Sirota [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 4:12 AM
To: [EMAIL PROTECTED]
Subject: Help with SELECT statement for date range
Hello,
I am having a problem when doing a
Maybe the weed has got me high right now, but here is something some of
you on this list may find funny, others may find this useful. This is
not spam, this is actually a good manual you should all read:
http://catb.org/~esr/faqs/smart-questions.html
Good Reading.
--
MySQL General Mailing Li
Here are two other books that I would recommend, specially the first
one:
* SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in
SQL
by Michael J. Hernandez, John L. Viescas
Joe Celko's SQL for Smarties: Advanced SQL Programming
by Joe Celko
-Original Message-
From: Fa
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I have added a FULLTEXT index to the tables I'm
Paul,
I just picked up your book today: MySQL Cookbook and I just wanted to
comment on how great it is.
I've spent hours at the bookstore looking through mySQL books, and by
far this is the best one I come across.
I strongly recommend it to anybody--Beginners, Intermediate, or Advanced
Users.
TASK:
I have to generate a report with all categories, subcategories and
products in database.
PROBLEM:
I want to write one query that will return:
1. category
2. subcategory: determined by parent_id
3. products in each category or subcategory.
I have four tables with the following structure:
-
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 15, 2003 2:
LOAD DATA INFILE "data.txt" INTO TABLE table_name FIELDS TERMINATED BY
'|' ENCLOSED BY '"' LINES TERMINATED BY '\n';
You can find more on this at:
http://www.mysql.com/doc/en/LOAD_DATA.html
-Original Message-
From: Rudolf Bekker [mailto:[EMAIL PROTECTED]
Sent: Monday, July 14, 2003 5:13
Joe Celko's SQL for Smarties: Advanced SQL Programming
By Joe Celko
-Original Message-
From: David Thompson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 4:21 AM
To: 'MySQL Mailing List'
Subject: Good Database Philosophy Book?
Looking for a book to help me develop a philosophy
