in mysql , how can you select the rows where 'some value' contains field


where field contains value works fine, but i need the reverse, along the lines of select * from table where 'somevalue' contains field, is it possible in mysql?


clarifying example

| version | ref |
| version1 | 1.1 |
| version2 | 1.1.1 |

select * from table where '1.1.1' contains ref

how to do the above?