CakePHP Questions

Hello,

I have a list of basketball players, whose numbers go from '00' to '99'. For this reason, I'm saving them as varchar on my database.

When I try to sort by Player.number, MySQL obviously sorts as varchar (1, 11, 12, 2, 20, ...).

Is there a way...

I want the paginator()-sort() to use LIKE instead of merely the field name. Since my field has multiple zip codes per user within it, it needs to 'SEARCH' for them rather than just sorting, it needs to search and then sort.

Here is my index() code...