search for: business_nam

Displaying 1 result from an estimated 1 matches for "business_nam".

Did you mean: business_name
2006 Jan 18
3
search with like operation from a table
I have a table with the list of business name and address in it. It may contain 1 million rows. The users want to look up into this table based on the business name. The simple solution is to use LIKE in mysql, but I am worried about performance, since the user load will be very high for this system. Any suggestion on how to handle the potential performance issue? How can i use a search