question

Rakesh_kp123 avatar image
Rakesh_kp123 asked

sql column result need to be filtered

sql column result is f0,f1.f2.f3.f4.f5.f6.f7.f8.f10,fa,fc,fb using where condition have to filter only f0-f10 without using IN commnd how this can be done .

sql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
anthony.green avatar image
anthony.green answered

You can use regex


Where result like ‘f[0-9]%’


So must start with F and then must be a numeric

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.