Untitled query #81470

SQL

select user_name, up_value as sign, LENGTH(up_value) as length from user_properties
inner join user on up_user = user_id
where up_property = 'nickname' and LENGTH(up_value) > 255
    /* ban spam result */
	and up_value not like '%专业%'
	and up_value not like '%广告%'
	and up_value not like '%网站%'
	and up_value not like '%电話%'
	and up_value not like '%信誉%'
	and up_value not like '%公司%'
	and up_value not like '%http%'
	and up_value not like '%www.%'
	and up_value not like '%开户%'
	and up_value not like '%缘分%'
	and up_value not like '%@gamil%'
    and user_name <> '朴妍123'
    and user_name <> 'Cnfzflw';
SQL

Checking query status...
