phpnewbie112 Posted November 23, 2007 Share Posted November 23, 2007 Hello, I have a table with a field "description" how can I use the 'where' to get a given word for example I need to query all records having the word "Peace" in their descriptions. thanks Link to comment https://forums.phpfreaks.com/topic/78553-solved-query-a-specific-word-inside-a-description-field/ Share on other sites More sharing options...
fenway Posted November 23, 2007 Share Posted November 23, 2007 1) WHERE description LIKE '%Peace% 2) Use a full-text index on this column. Link to comment https://forums.phpfreaks.com/topic/78553-solved-query-a-specific-word-inside-a-description-field/#findComment-397512 Share on other sites More sharing options...
phpnewbie112 Posted November 23, 2007 Author Share Posted November 23, 2007 thanks a lot Link to comment https://forums.phpfreaks.com/topic/78553-solved-query-a-specific-word-inside-a-description-field/#findComment-397514 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.