Summary of the use of the like keyword in Oracle

Summary of the use of the like keyword in Oracle

Use like in Oracle for fuzzy search:

Assume that the table name is hs_test, and the field name is client_id.

1. query which has 03 in client_id:

Select client_id from hs_test where client_id like '% 100'

2. query client_id values starting with 03:

Select client_id from hs_test where client_id like '201312'

3. query the client_id ending with 03:

Select client_id from hs_test where client_id like '% 03'

4. query which client_id contains letters:

Select client_id from hs_test where client_id like '% [a-z] %'

5. query which client_id contains numbers:

Select client_id from hs_test where client_id like '% [0-9] %'

Others can be extended based on the above several forms, which will not be described here.