I am developing a simple keyword search using php and mysql and I am facing problem while using "AND" and "PARENTHESIS" advanced search where user inputs the query. I developed following sql query:
Select * from Page LEFT JOIN Page_Tag LEFT JOIN Tag where((name="events" and name="news") or name="local")
I am not getting the answer of the "and" operation whereas "or" operation works properly.
And in parenthesis search, how do i parse input.