sql error

[TravisB]

I have an sql statement like:
SELECT * FROM mytable WHERE url = http://www.mysite.com

And I recieve this error:
You have an error in your SQL syntax near '://www.mysite.com' at line 1

I thought it might be the : after http, so I tried this:
SELECT * FROM mytable WHERE url = http://www.mysite.com

and got this:
You have an error in your SQL syntax near '\://www.mysite.com' at line 1

Any ideas?

[John_Canyon]

SELECT * FROM mytable WHERE url='http://www.mysite.com'

That will work. Make sure to encapsulate your strings in quotation marks.

Cheers.

[TravisB]

Yep, putting quotes around it like 'http://www.mysite.com' worked. Thanks.