I am working on an auto suggest and I would like people to be able to either type in a product number or product name. So for example
If they start to type 1234 it will start to show the products
12345: The Product 1
12346: The Product 2
Or if they type in Product
It would show the same results
So how can i can I concatenate the product id and product name in a query and have it format like that, even with the colon in it?