2. PHPRunner General questions
  3. Free text search in advanced search
This topic is locked

Free text search in advanced search

 		5/25/2009 7:14:41 PM
PHPRunner General questions
W
 webmanager author

I have an advanced search page, it has three drop downs (lookup table) but my client now needs to add a single text search that will search multiple fields.
Any quick and easy solutions or passed threads? Any help would be great.
J
 		Jane 5/26/2009

Hi,
you can create alias and concat three fields on theEdit SQL querytab:

select concat(field1,' ',field2,' ',field3) as field1_field2_field3,

..

from TableName
W
 		webmanager author 5/27/2009

Hi,

you can create alias and concat three fields on theEdit SQL querytab:


That's great! thanks again Jane