There is a view column

1 11 12 2 21 211 3 31 

You need to make a sql query that would display this column completely, but take into account only single digits in limit. For example, if you make a query to this column

 *запрос* limit 2 

it would be

  1 11 12 2 21 211 

Varchar column, mysql database

    2 answers 2

    You can compare writing in where column <10

     select * from table where column < 10 

      Limit limits the number of rows by quantity, not quality. Perhaps so:

       select * from table where column < '3' order by column