Re: Find number between 1-10 in data
Not exactly. My table has a colum with:
id | Name | logo | fk_location_ids | enabled
1 | Test Group | logo.jpg | 1-10 | Yes
I have a location table that has:
id | Location name
2 | Test Site
When I select from the from I am getting the location id of 2 and need to find out what group or groups the location belongs to. Since 2 is between 1-10, I should get the test group returned in the result set.
FIND_IN_SET and IN doesn't seem to know to look in that whole through (-) grouping of 1 thru 10.
Mysql server ver 5.1
Subject
Written By
Posted
Re: Find number between 1-10 in data
June 03, 2014 09:43PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.