Searching with no conditional "LIKE"

cdiazr

Hi, I'm working for a customer who wants to search using "=" not "like". He got a datatables searching by columns so he wants to search by first characers. Is it possible searching on that way with datatables? If yes, ¿how I have to set it up?

Thanks

cdiazr

Ops!! I'm really sorry, I was wrong. (need more coffee hehehe). I mean, currently datatables is searching like this:

"WHERE field LIKE %pattern%.

So, I want to search like this:

"WHERE field LIKE pattern%

Now yes, sorry again!