How to do a field search if the field value is a range?

Question

MySQL

Hello.
The database has a price column - a varchar type field, where approximately the following values ​​are stored
: 1. NULL
2. 100
3. 5000
4. 100-250 - range (there are problems with it)
I need to do a search, find all records where the price is higher 50 (should show 2-4)
or find everything where the price is between 100 and 500 (should show 2, 4)
How do I search in a range? Is it possible to split a value by "-" character in MySQL ?

Answer 1

1. kill your DBA
2. redo the table - enter price_min and price_max.
The first item is required, the second is optional.

Answer 2

Divide by two normal ints (or decimal if you need fractional ones)