How can I fetch rows using numeric values as condition?

Question

A colum in my databse table has alphanumeric values. I want to get only the rows, having numeric values in this column.

$this->Mymodel->find('all', 
    'condition' => array('Mymodel.field') => ???)
);

Please always mention your exact CakePHP version, and when it's about queries don't forget the DBMS/Schema details. http://stackoverflow.com/q/5064977 | http://stackoverflow.com/q/338075 | http://stackoverflow.com/q/16195986 etc... — ndm, Apr 23 '14 at 21:30

score 3 · Accepted Answer · edited Apr 24 '14 at 05:13

3

If you're using MySQL, you could use Regular Expressions.

$this->Mymodel->find('all', 'conditions' => array('Mymodel.field REGEXP "^[0-9]+$"'));

edited Apr 24 '14 at 05:13

Rajeev Ranjan

answered Apr 23 '14 at 21:29

Kai

1 Answers1