Re: Adapting a Select statement to MySQL

2003-11-04 Thread 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

Adapting a Select statement to MySQL

2003-11-03 Thread Jim Bartram
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: