and not or, in searches

[roxiroxi]

Hi people, anyone has any example of how i can add these operators into my search???? I cant get any

I mean, when a user enter the film batman and returns, it searches films with batman and returns words

Thanks

[micky1955]

you can use AND & OR as follows:

$search1 = "Batman";
$search2 = "Returns";

SELECT * FROM DBASE WHERE Title LIKE '%$search1%' [color=red]OR[/color] Title LIKE '%$search2%' ;

SELECT * FROM DBASE WHERE Title LIKE '%$search1%' [color=red]AND[/color] Title LIKE '%$search2%' ;

using [color=red]LIKE[/color]  with the [color=red]%%[/color] option means that for a result the search text must be found somewhere in the field.