search queary

[bluetiger]

I want to search multiple coloums on my database, I can get it to work searching one cloum with this queary

 

SELECT *
FROM Profile
WHERE Profile.Location1 = colname

 

I tried this

SELECT *
FROM Profile
WHERE Profile.Location1 = colname OR Profile.Location2 = colname OR Profile.Location3 = colname

 

ANY ONE HELP!?

 

Location1, 2,3 all have different areas in the some have three filled in some only two etc eg

 

location1 birmingham

location2 london

location3 brighton

 

If the user searchs for 'brighton' i want it to search all three coloums and if one has the correct result I want to display it

[trq]

SELECT *
FROM Profile
WHERE Location1 = 'colname'
OR Location2 = 'colname'
OR Location3 = 'colname';