Jump to content

sql queries


jess
 Share

Recommended Posts

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 :)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...