Or function in MySQL

[pablodelapena]

does it exist? I tried soemthing and it did, but then i wasnt sure if my syntax was correct

$query = "SELECT * FROM photos WHERE name LIKE '%$keyword%' OR keywords LIKE '%$keyword%'";

that work?

[stolzyboy]

that should work

[pablodelapena]

no errors, but if it yped a query which was only in the keyword colomn no results came up

[stolzyboy]

well then i would check to see if the keywords field is left blank, and only use that sql statement if it is used, otherwise, use a different one on only a certain field