Get the App
SLTechnology News&Howtos  ›  Database  › 

Sqlserver query contains an element in a field

Shulou Source: shulou.com Published: 2022-06-01 11:22:42 10月05日 Update

For example, two pieces of data have the same number.

10,101,12,14

10,104,15,16

To find the 10 in it, you don't need to find 101104.

It is OK to use the condition of charindex (', 10 ~ (10)) in sqlserver.

It is OK to use where FIND_IN_SET ('10 hundred minutes dependency) in mysql.

The Dependency here is the field you need to find.

Tags: Fields same data conditions elements queries Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Huawei Xiaomi Apple OPPO Reno Shulou Technology