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?
| version | ref |
| version1 | 1.1 |
| version2 | 1.1.1 |
select * from table where '1.1.1' contains ref
how to do the above?