selecting rows that contain pattern as a subset
Posted: Sat Oct 08, 2005 5:14 pm
I have a table with only one column with values like
row1 = a123 , row2 = 231 , row3 = 1233 , row4 = 123
how would I select all rows that contain "123" so that rows 1 , 3 , 4 would be a match?
row1 = a123 , row2 = 231 , row3 = 1233 , row4 = 123
how would I select all rows that contain "123" so that rows 1 , 3 , 4 would be a match?