Tuesday, 6 August 2013

sql wildcards escape multi char

sql wildcards escape multi char

When escape single char we can do like this:
select * from tableName where columnName like 'CU_C' escape '_';
But eacape multi char("% " and "_"):
select * from tableName where columnName like 'C%U_C' escape ??;
How can i do to success?Or using other way?

No comments:

Post a Comment