I have the below table from which I need to filter which holds both "g / ml". The below query gives me result as The expected result is What I can apply in the where clause to get the expected results Answer Just use %g/%ml%. The % can appear in any position in the matching pattern.

filter the result by ‘g / ml’ using SQL

I have the below table from which I need to filter which holds both “g / ml”.

name            product
----------------------------------
Sunflower oil       pure 180g/200ml @Rs.20
groundnut oil       gold 300g @Rs.25
Olive oil       Filter 470g/500ml @Rs.30
coconut oil     Filter 1000ml @Rs.30

​x
 
name            product----------------------------------Sunflower oil       pure 180g/200ml @Rs.20groundnut oil       gold 300g @Rs.25Olive oil       Filter 470g/500ml @Rs.30coconut oil     Filter 1000ml @Rs.30​

The below query gives me result as

select Name, product
from Logistic
where product like '%ml%'

 
select Name, productfrom Logisticwhere product like '%ml%'​

name            product
----------------------------------
Sunflower oil       pure 180g/200ml @Rs.20
Olive oil       Filter 470g/500ml @Rs.30
coconut oil     Filter 1000ml @Rs.30

 
name            product----------------------------------Sunflower oil       pure 180g/200ml @Rs.20Olive oil       Filter 470g/500ml @Rs.30coconut oil     Filter 1000ml @Rs.30​

The expected result is

name            product
----------------------------------
Sunflower oil       pure 180g/200ml @Rs.20
Olive oil       Filter 470g/500ml @Rs.30

 
name            product----------------------------------Sunflower oil       pure 180g/200ml @Rs.20Olive oil       Filter 470g/500ml @Rs.30​

What I can apply in the where clause to get the expected results

Answer

Just use %g/%ml%. The % can appear in any position in the matching pattern.

Advertisement

Answer