Fuzzy search

Got a quick question for us? This forum doesn't require registration so you can ask quick and be on your way!
UPDATE - Spammers be gone. This forum is closed to non-registered posts for the time being because of spammers.

Fuzzy search

Postby ChrisMck » Mon Jul 19, 2010 7:50 am

Hi

I need to search the contents of a field for a job number and then display all of the records that contain that job number. My problem is that the data is an export from an accounts package and the field contains the job number plus the address and there is no logic to its input. For example:

12345, 1 The High Street London or High Street 12345

Is it possible to add a contains or like criteria to the search query?

Chris
ChrisMck
 
Posts: 1
Joined: Mon Jul 19, 2010 7:45 am

Re: Fuzzy search

Postby admin » Sat Aug 14, 2010 12:15 pm

Should be indeed, though unfortunately, a limitation with MySQLi means this only works if your server has the PDO extension. More on this here:

http://www.formboss.net/help_support/fo ... okensearch

I will of course be expending this feature to allow for more control, as well as doing what I can to work arounf the MySQLi bug.
admin
Site Admin
 
Posts: 421
Joined: Sat Sep 27, 2008 11:02 am


Return to Quick Questions - No Registration Required - Or Not

Who is online

Users browsing this forum: No registered users and 1 guest

cron