Re: Dictionary

What you are looking for is called a Word List. I would search for something like the following: "word list" spellcheck DanB "Scott Hamm" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] I've been trying to google to no avail for English dictionary (with definitions) in any format th

Re: Query: Order for the Earliest Latest date

"Peter Brawley" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Dan, > >>I'm trying to generate a list of sites that HAD a support incident within >>a known date range, and order them so that the site that has the OLDEST >>support call is FIRST in the list. > > It's the (oft-asked-

Query: Order for the Earliest Latest date

[GENERAL INFO] I have two tables I'm working with. One table (Sites) contains contact information for every customer site that we deal with. The other table (Incidents) contains all the support calls we've made. [QUERY] I'm trying to generate a list of sites that HAD a support incident within a

Re: Tips for better performance

"Marko Knezevic" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Here are my tables and queries i am running on them with index explanations. Hope this will help. ACCOUNTS TABLE: +-+--+--+-+-+ | Field

Re: Optimizing query "WHERE date>0"

"Devananda" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Dan Baker wrote: >> "Eric Bergen" <[EMAIL PROTECTED]> wrote in message >> news:[EMAIL PROTECTED] >> >>>When you add that index are more than 30% of the row

Re: Optimizing query "WHERE date>0"

an something of interest? If so, what? Thanks DanB > Dan Baker wrote: > >>I have lots of tables that are similar in nature: >> >>id int(11) PRI NULL auto_increment >>Name varchar(30) >>DateTimeNext int(11) >> >>The "DateTimeNext" field

Optimizing query "WHERE date>0"

I have lots of tables that are similar in nature: id int(11) PRI NULL auto_increment Name varchar(30) DateTimeNext int(11) The "DateTimeNext" field represents when this records needs attention. A value of zero indicates it is being ignored. There are times when *lots* of records DateTimeNext

Stored function

I'm running "MySQL 4.0.23-standard", and trying to create a stored function. Am I doing something wrong, or can I not create a stored function in 4.0.23? What I want is a stored function to take an int from a column and alter it (mask off the low 16-bits). SQL-query : CREATE FUNCTION hello( s C

Re: Birthday strategy

"Pooly" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Hi, I would like to display a list of members who have their birthday a given day (today for instance). My idea is to store their birth date in a column, and then query the table against the column. But the query would be like :

Re: Partial Filtering

"Blue Wave Software" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm having one of those slow brain days. > > I want a partial filter egg. All records where field1 begins with "ABC" > any > body know the where clause to do this. > > In Access it's where field1 = 'ABC*' but I can