Re: Adapting a Select statement to MySQL

[Jim Bartram]

Looks like there's a bug in SQLyog -- when I restarted my machine this 
morning, the query worked.

Thanks,

-Jim

Nitin wrote:
query seems perfect, what error is this giving?

Nitin

----- Original Message ----- 
From: "Jim Bartram" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 04, 2003 10:07 AM
Subject: Adapting a Select statement to MySQL



I've got the following select statement that is defeating me!

select title_id, ytd_sales from titles
where ytd_sales between 4095 and 12000;
The WHERE clause is not working... How should this be done in MySQL?

Thanks for any help,

-Jim



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]








--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]