Like的模糊查询
sqlsrv:
$UploaderID = strval( $_GET[ 'UploaderID' ] );
///防止参数乱码
$UploaderID = iconv( "UTF-8", "GB2312//IGNORE", $UploaderID );
////sql语句
$sql = "SELECT
*
FROM
StandardResources
WHERE
UploaderID
like '%".$UploaderID."%' ";
//// 参数
$params = array( $UploaderID );
oracle :
select * from table_name where 1=1
<#if secondName?? && secondName?has_content>
and second_name like '%'||:secondName||'%'
</#if>
mysql:
select * from table_name where 1=1
<#if secondName?? && secondName?has_content>
and second_name like concat('%', :second_name ,'%')
</#if>