LIKE Operator or any Equiavelant

Adalat Khan

6y788SQL

I have a string field Bands in which i stored some fixed numeric values such as 41, 78, 800, 1800. These values are stored in the Bands field as comma separated. Now to get a single value from this field i used MySql query LIKE operator. Suppose if i want to take the valuee 800 then i am using the following query:

Select * from CapacityRequest where Bands LIKE ('%800%')

This query returns only 800 that is perfect but when i want to retrieve the value 1800 then it returns both 800 and 1800 for example:

Select * from CapacityRequest where Bands LIKE ('%1800%')

The above query returns both 800 and 1800 but i only want 1800 not 800. I also used the following query but it also not working:

Select * from CapacityRequest where Bands LIKE ('%18%')

The above query also returns both 800 and 1800. How to fix this issue?.

I am using this query in C#

Thanks in ADVANCE.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Adalat Khan6y ago
[Appearance("AverageLoadCollocatedCellsBand1800Hide", AppearanceItemType = "ViewItem", Criteria = "Bands NOT LIKE ('%1800%')", Visibility = ViewItemVisibility.Hide, Context = "DetailView")]

Sir actually i am not using the actual sql query but i am using the like operator in the show hide attribute. I want to hide a field if the bands field contains 1800. when the Bands field is concatenated two band value such as 800, 1800 separated by comma then it not works. So in this case i thing i cannot create a function. If the function is working in this case so could you please how?
Amit Gupta6y ago
% symbol seeks any character, you will got stuck when you use % in suffix or prefix. Alternatively you can create a function that splits your data followed by , (comma) and then use = (equals symbol to filter your data)
Adalat Khan6y ago
Bands = 1800,800,2100

Rajanikant Hawaldar
Sir it works but in the above case it does not work. Could you please try in the above case.
Rajanikant Hawaldar6y ago
Try : Select * from CapacityRequest where Bands LIKE ('%800')

LIKE Operator or any Equiavelant

Rajanikant Hawaldar