SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
-
Nov 21, 2009, 06:35 #1
- Join Date
- Nov 2007
- Location
- Malaga, Spain
- Posts
- 1,072
- Mentioned
- 4 Post(s)
- Tagged
- 0 Thread(s)
select * where value contains field
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?
-
Nov 21, 2009, 07:28 #2
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
-
Nov 21, 2009, 07:36 #3
- Join Date
- May 2009
- Location
- Jomtien, Pattaya, Thailand
- Posts
- 910
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Please try to explain your problem better because I don't get it.
From what I understand you simply want:
WHERE ref='ref'Do you really need traffic? Where to? What for?
If you really do need traffic then stop messing around!
Advertise on my sites today: She Told Me & Best Reviewer :
200,000+ UV / Month
-
Nov 21, 2009, 07:36 #4
-
Nov 21, 2009, 22:02 #5WHERE '1.1.1' LIKE CONCAT('%',ref,'%')
I am noting this.
Bookmarks