MySQL Keyword Search

[SP8600]

Can anyone tell me why this MySQL statement will bring back the $value (which is a keyword in an input box for a search, sent vie post) for news_title however it will not bring back the keywords for full_news. The data types are Varchar(100) for news_title and TEXT for full_news.

$searchResult = mysql_query("SELECT * FROM news WHERE news_title LIKE '$value%' OR full_news LIKE '$value%' ORDER BY news_id DESC LIMIT $limit");

[ScubaKing22]

Perhaps it is because you are using OR in between. Try switching it to AND and see what happens.

[SP8600]

I need to use OR though because AND will have to have the word in both columns.

[ScubaKing22]

Have you checked to make sure that full_news contains any information relevant to the search?

[SP8600]

Yes of course i have.

[ScubaKing22]

Perhaps it has something to do with the LIMIT. Maybe the full_news match occurs after the specified limit. Try taking that out and see what happens.

[SP8600]

I did try that and it didnt work, however i believe it maybe a small bug because i was trying the keyword "content" and when i changed that word it worked :S

Thanks for your help anyway.

[stolzyboy]

try changing these

'$value%'

to this

'%$value%'

[SP8600]

Ok, i solved it "somehow". Now what i am wondering is can i anyway stop pages from being listed in the search if it has already been brought back from the database. The primary key is "id" if that is needed. The code is below

$splitSearch = preg_split('/[\s,+]+/', $_POST["keywords"], -1, PREG_SPLIT_NO_EMPTY);
						 		foreach($splitSearch as $key => $value) { 
									$searchResult = mysql_query("SELECT * FROM news WHERE news_title LIKE '%$value%' OR full_news LIKE '%$value%' ORDER BY news_id DESC LIMIT $limit");
									while($searchResultArray = mysql_fetch_array($searchResult)) {
										echo $searchResultArray["news_id"];
									}
								}