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