mysql query

[Prellyan]

Hey there,

I would like to be able to select * from a table where one of a number of fields may = a variable

I think i need to use AND|OR ruotine but cant find anything on the syntax that makes sense.

SELECT *
FROM projectdata
WHERE projectdata.proauthone AND|OR projectdata.proauthtwo AND|OR projectdata.proauththree = 'authuser'

any help would be great

thanks

[Prellyan]

thanks i got it now

[Drakla]

If you have discovered the solution to a problem yourself post the results in the thread so other people can learn from it, and use the thread tools to mark the thread resolved. Also consider deleting the thread if it offers nothing constructive.

[Prellyan]

SELECT *
FROM projectdata
WHERE proauthone = 'authuser'
OR proauthtwo = 'authuser'
OR proauththree = 'authuser'