Simple SQL QUestion

[united07]

I work with a database on Intenet sites

I am trying to work out people who visit Home Pages only and no other part of a domain.

Is there a way in SQL I can search for '

http://www.westapc.com.au'

exclusively and nothing which comes after eg /homeloans?

 

[JarlH]

Use the LIKE functionality:

SELECT * FROM tablename
WHERE columnname LIKE '

http://www.westapc.com.au%'

The % above is a wildcard. You may be used to *, which is used as wildcard character in many other places. But in SQL you use %.

If needed, you can even put another % in the beginning of the string, to make it insensitive for '

http://':

SELECT * FROM tablename
WHERE columnname LIKE '%

http://www.westapc.com.au%'

Hope that helps.

 

[r937]

in this case it would be LIKE '%www.westapc.com.au' so that you select only those instances which have nothing after the '

http://www.westapc.com.au'

rudy

http://r937.com/

SQL Consulting

 

[JarlH]

Oops... Thanks for the correction.