How to write a SQL exact match specific characters in a field?

The Oracle database, a table A field x, content is "2344324448888", "," used to partition data

How do I write SQL, when I want to precisely match a field inside a comma separated?
For example, enter 888 or 8888 matching, matching; 44 do not match, the 444 can match. Like this
Regexp_like seems to be the only a partial match, I really had no idea

Started by Wright at November 09, 2016 - 1:01 PM

There's no procedures can be used to deal with

Posted by maker at November 13, 2016 - 1:48 PM

I really halo. You have to use SQL query as a regular. . .
SQL query the basic results on the line, the remaining on the service layer to solve (logical solution)

Posted by Jackson at November 17, 2016 - 2:06 PM

Agree with upstairs.

Posted by Nancy at November 30, 2016 - 2:10 PM

Long live Java

Posted by Arvin at December 12, 2016 - 2:47 PM

You really want to make it a custom function, want to how how to engage in, but such a high maintenance costs.

Posted by Quintion at December 18, 2016 - 3:31 PM

You can put a x field to query. Then press the comma, finally SQL queries to find data in the segmentation result is it right?.

Posted by Porter at December 19, 2016 - 3:54 PM

Let me show you.

Posted by Porter at December 25, 2016 - 4:22 PM

If you want a simple, need to modify the A field in X minor, can be done in PRC, or when inserted into the line.
"2344324448888" is found on the length uncertainty, enter "888", will match this should not match."8888",
Then we make the following changes:
The "2344324448888" into ", 2344324448888," to use ", 888," matching,
It will be in the original basis of minimal changes, also use the minimum amount of code to solve this problem, whether it is feasible to have a look.

Posted by Natalie at December 26, 2016 - 4:52 PM