Results 1 to 4 of 4
Thread: RE: SQL Filter Question
May 23, 2012, 06:04 #1
- Join Date
- Oct 2005
- 0 Post(s)
- 0 Thread(s)
RE: SQL Filter Question
I'm trying to do a SQL query where it filters the result set for a search on a website.
The search is meant to filter if its a news post or a faq or all site.
It uses a number to identify which one however the SQL query always returns the same amount of rows.
SELECT DISTINCT searches.search_page_area, searches.search_page_key, searches.search_page_content, searches.search_page_title, searches.search_page_description FROM searches WHERE searches.search_page_area = 2 AND searches.search_page_title LIKE '%water%' OR searches.search_page_description LIKE '%water%' OR searches.search_page_keywords LIKE '%water%'
Could anyone help?