February 7th, 2014, 07:11 AM
Advice to implement a search for a big table
Now I want to implement a search option with regex support but I'm not sure what the best way is to do it. I need the search on all the rows (not only the rows of the current page).
I'm not sure if it's possible to use regex in an sql query (I searched a bit on Google but didn't really find anything that helped me). The other option would be to query all the rows and filter them on the server.
What would you do? Is there another option I didn't think of?