Doyley Posted November 6, 2005 Share Posted November 6, 2005 Hi all, Im creating a search query which will allow our customers to search our database to select a product they are looking for. The MySQL query is below... SELECT * FROM products WHERE MATCH(products_description) AGAINST ('$query' IN BOOLEAN MODE) The problem is, it doesnt work if there are less than 4 characters which would cause a problem if somebody searched for "cue" which will happen a lot as it is a 8 ball pool shop. Is there a workaround for this? Many thanks Quote Link to comment https://forums.phpfreaks.com/topic/2809-boolean-mode/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.