I like the script at http://www.datatables.net/development/server-side/php_mysql, but do you have one available with regex enabled? Is that even possible with MySQL's limited regex support? Thanks!
It should be fairly easy to use regular expressions in the WHERE query - you just need to modify the syntax to match what you need using the MySQL supported regex options: http://dev.mysql.com/doc/refman/5.1/en/regexp.html . The hard bit is probably doing regex over multiple columns. If you are looking for smart filtering like DataTables, have a look at this thread: http://datatables.net/forums/comments.php?DiscussionID=3343&page=1#Item_6
Replies
It should be fairly easy to use regular expressions in the WHERE query - you just need to modify the syntax to match what you need using the MySQL supported regex options: http://dev.mysql.com/doc/refman/5.1/en/regexp.html . The hard bit is probably doing regex over multiple columns. If you are looking for smart filtering like DataTables, have a look at this thread: http://datatables.net/forums/comments.php?DiscussionID=3343&page=1#Item_6
Allan