Search

I am asking for word boundary search regex which I know is \bword\b but this ignores all the special characters

query->where( $this->_ssp_field( $http, $i ), '%'.$search.'%', 'like' ); to be: $query->where(

You'd need to strip the £ symbol before converting the string to a number in the search function value.replace('£', '') should do that. Allan

I uses for the search is no more more

current state of the searches for the table and

script is handling that search request. My PHP isn't

You can use the below to search all tables on the page: $('table.dataTable').DataTable().search( 'search text' ).draw(); Kevin

in a table, the search does work event when

Are you also loading jquery.dataTables.js? If you can't provide a test case at least post your JS code showing the Datatables init code and the code for the search boxes. Kevin

Thanks, Kevin. I solved it this way: $('#myInputTextField').keyup(function(){ var searchTerm = this.value.toLowerCase(); $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) { //search only in the following columns (0 and 1) with OR operator if (~data[0].toLowerCase().indexOf(searchTerm)) return true; if (~data[1].toLowerCase().indexOf(searchTerm)) return true; return false; }) table.draw(); $.fn.dataTable.ext.search.pop(); })