Helpfulbox Now Offers Free POS Software for restaurants, kiosk, and any other retails business completely free used windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, al for free.

What is the best way to create most accurate fast search using mysql or millions of rows?

Date: Thu-Jan-7-2016-
Response
0
Using boolean mode with + on each words give you very best result. Here is exampl

SELECT userque,userquecatgory,queid,MATCH(userque) AGAINST('+your +search +here +okay' IN BOOLEAN MODE) AS relevance FROM $tmpresul WHERE MATCH(userque) AGAINST('+your +search +here +okay' IN BOOLEAN MODE)LIMIT 4)")
[d] By: humiliating
Date: Tue-Jan-12-2016
Response
What is 1 + 100



Helpfulbox Now Offers Free POS Software

for restaurants, kiosk, and any other retails business completely free. It can be used as windows cashier system or as full blown POS. You will able to print to kitchen, display orders on the kitchen screen, manage inventory, employee, report, customer loyalty offers, employee management, delivery address track and much more, all for free.

Just Updated::