b********t
发帖数: 168 | 1 I can use
where name in ('name1','name2','name3')
but how to use
where name in ('%name1','%name2','%name3') , it does not work with wildcard.
Thanks | c**t
发帖数: 2744 | 2 regexp_like( name, '*name[123]+$')
wildcard.
【在 b********t 的大作中提到】
: I can use
: where name in ('name1','name2','name3')
: but how to use
: where name in ('%name1','%name2','%name3') , it does not work with wildcard.
: Thanks
| n********6
发帖数: 1511 | | c**t
发帖数: 2744 | 4 this is sql server style, oracle doesn't support
【在 n********6 的大作中提到】
: name like '%name[1-3]'?
|
|
