select * where value contains field

[YuriKolovsky]

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?

[r937]

clarifying example

sorry, example did not clarify

is this what you mean?

WHERE '1.1.1' LIKE CONCAT('%',ref,'%')

[JamesColin]

Please try to explain your problem better because I don't get it.

From what I understand you simply want:
WHERE ref='ref'

[YuriKolovsky]

sorry, example did not clarify

is this what you mean?

WHERE '1.1.1' LIKE CONCAT('%',ref,'%')

i think i do

yes, it works perfectly, thanks!!

[PHPycho]

WHERE '1.1.1' LIKE CONCAT('%',ref,'%')

Great concept !!
I am noting this.