Search multiple columns
Search multiple columns
Hi there,
First off I've got to say how amazing this plugin is. I was looking for an alternative to jquery.tablesorter and this is just perfect! So hats off to you..
Anyway, one thing that's causing me a problem is the following.
Just for example, say I have 3 columns in my table (`member_firstname`,`mebmer_lastname`,`member_email`) and a row in the table contains the data 'Lee', 'Brooks', 'lbrooks@webforma.co.uk' if I search 'lee' the result is returned fine, and the same if I search the data from the other fields.
However I'd like to be able to search 'Lee Brooks' and have the data returned.
I'm using the server side script with MySQl.
Any help would be greatly appreciated :)
I've tried searching but couldn't find anything relevant.
Thanks in advance,
Lee.
First off I've got to say how amazing this plugin is. I was looking for an alternative to jquery.tablesorter and this is just perfect! So hats off to you..
Anyway, one thing that's causing me a problem is the following.
Just for example, say I have 3 columns in my table (`member_firstname`,`mebmer_lastname`,`member_email`) and a row in the table contains the data 'Lee', 'Brooks', 'lbrooks@webforma.co.uk' if I search 'lee' the result is returned fine, and the same if I search the data from the other fields.
However I'd like to be able to search 'Lee Brooks' and have the data returned.
I'm using the server side script with MySQl.
Any help would be greatly appreciated :)
I've tried searching but couldn't find anything relevant.
Thanks in advance,
Lee.
This discussion has been closed.