I have a table named table with a varchar type string in it there are two columns, col1 and col2. Columns are clogged with floating point values, for example: col1 = 2.234 col2 = 5.212; ...
I am making a query for sql php (redbeanphp)
$sql = R::find( 'table', 'col1 BETWEEN 1.75 AND 3.78 AND col2 BETWEEN 4.53 AND 5.55' );
but it returns nothing.
If I make a request through phpmyadmin SELECT * FROM `shops` WHERE col1 BETWEEN 1.75 AND 3.78 AND col2 BETWEEN 4.53 AND 5.55
then everything works.