Select from mysql database

vladakg · #1 (**permalink**) 08-17-10, 11:33

Can I somehow from the database to found a just determination of the data, namely, I would like if I can somehow found what I want to found a through id. Example: I would like to found a data only where the id is even or odd number, or only the data whose id is less than the number 5, or higher than the number 6 .. Can anyone help me?

gvee · #2 (**permalink**) 08-17-10, 11:53

Odd numbers

Code:

WHERE  number_field % 2 = 1

Even numbers

Code:

WHERE  number_field % 2 = 0

Less than 5

Code:

WHERE  number_field < 5

Greater than 6

Code:

WHERE  number_field > 6

gvee · #3 (**permalink**) 08-17-10, 11:54

The odds and evens ue the Modulo operator. More info here: MySQL :: MySQL 5.0 Reference Manual :: 11.6.2 Mathematical Functions

vladakg · #4 (**permalink**) 08-17-10, 11:59

Thanks man, u rescue me

vladakg · #5 (**permalink**) 08-17-10, 12:17

I have one more question. Can someone, call from database only articles where is first letter of name begin from A and end with first name letter T . Just call articels between that thow letters?

gvee · #6 (**permalink**) 08-17-10, 12:51

vladakg,

You really need to look in the manual more

Here's one easy method

Code:

WHERE  Left(name, 1) BETWEEN 'A' AND 'T'

vladakg · #7 (**permalink**) 08-17-10, 13:06

Thanks again

Internet Services

Web Development

Digital Marketing

Consumer Tech