SQL problems on expressions would not work

Asked By martin nievera 0 points N/A Posted on - 11/02/2011

Is there anyone who has discovered that SQL expressions cannot work with the word “between” for the shape file?

But otherwise it can work if an equivalent is used for example “SELECT*then the variables given. 

What other options should I use?

Anyone with different opinion, please give your helpful tips on this

• Status: Open
• Question Views: 828
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Clair Charles 15 points N/A #100807

SQL problems on expressions would not work

I am guessing you need to use an SQL expression to find the range between values. To do that you can use the BETWEEN, or alternatively the operation which will be used to determine whether the value of an expression is within a specified range or values. Such an expression comes in handy when you have a list of things that you want to mark, without having to go through a large database to find them.

The SQL syntax for the BETWEEN expression is as indicate below:

expr [Not] Between value1 And value2

Or:

SELECT columns

FROM tables

WHERE column1 between value1 and value2;
 

Not that the BETWEEN expression is side by side with the AND expression.

 

-Clair Charles

 

About Clair Charles

Questions
1

Answers
495

Best Answers
109

• Vote Up 0 Vote Down

• Posted on - 12/19/2011
• Question Category: MySQL Server