Jump to content


This topic is now archived and is closed to further replies.


Boolean Mode

Recommended Posts

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

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.