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