how to find if a string exists in oracle column

Question

i have a table that store mutiple values in column i need to find if the value exists then return entire row

Example : 963963963;35793579;741741

Query am using

select * from table where column like (%963%);

which return all the rows that have the value starts or ends with 963

i need only one row that match with 963

Tim Biegeleisen · Accepted Answer · 2023-02-02 03:28:04Z

1

It is generally bad table design to store semicolon separated data this way. If you must continue with your current design, you may use the following query to find an exact match for 963:

SELECT *
FROM yourTable
WHERE ';' || col || ';' LIKE '%;963;%';

answered Feb 2, 2023 at 3:28

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to find if a string exists in oracle column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related