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 11月19日 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 Docker OPPO Reno Shulou Tech Info MariaDB Shulou Information