A query with a pattern match condition? <<ULTRA difficult Question>>

[onedumbcoder]

Hi guys,

 

lets say I have table with a field called code.

 

is it possible to do a query where I look at the values in code and see if a patter occurs?

 

for Example

 

code = "ABCDE"

 

and I want to see if  CDE occurs in there and if so get it, so something like this:

 

"select * from paper WHERE code has pattern CDE"

[jonsjava]

SELECT * FROM paper WHERE code LIKE '%CDE%';

[onedumbcoder]

is it possible to determine where the nth element is lets say C?

 

for example

 

select * from paper where code[nth] = 'C'?

 

[effigy]

SUBSTR

[947740]

Quite the ultra-difficult question.

[onedumbcoder]

so this would work?

 

select * from paper WHERE SUBSTRING(code, -1, 1)= 'C'

[rhodesa]

select * from paper WHERE SUBSTRING(code, -1)= 'C'

The last argument is not needed. But the that would return anything where the value of code ends with a C.

This produces the same result:

select * from paper WHERE code LIKE '%C'

 

[onedumbcoder]

Thanks for all the help so far.

 

I understand % means anything goes:  for example    %C  get everything that ends with C  C% ... that starts with C

And I guess I could even do  %C%C%?

 

Are there any one symbols used besides %? if so can you please mention them and their influence.

 

[sasa]

_ replace one caracter