sql queries

[jess]

hi alli'm new to sql and i'm creating a hoilday. i need to create a query to show all the sites visited with a difficulty description longer than 6 characters which only displays the sites once. can any one help me with this because i have no idea.thanksjessica

[Synook]

Umm... a holiday in SQL? :)Well, if you are using MySQL you can utilise the LEN() function to find out the length of a field, e.g.

SELECT * FROM sites WHERE LEN(difficulty_desc) > 6

[jess]

Umm... a holiday in SQL? :)Well, if you are using MySQL you can utilise the LEN() function to find out the length of a field, e.g.

SELECT * FROM sites WHERE LEN(difficulty_desc) > 6

hithank you i'll try thatthanksjess

[jess]

hii was wondering if anyone knows how to create a query which shows the hoilday and site details that commence in the calender month that follows the current month. thanks jessica

[justsomeguy]

I'm not sure which database you're using, but this should work for a MySQL database:SELECT * FROM table WHERE MONTH(date_column) = MONTH(DATE_ADD(CURDATE(), INTERVAL 1 MONTH)) AND YEAR(date_column) = YEAR(DATE_ADD(CURDATE(), INTERVAL 1 MONTH))