Select sum sum with fuzzy query how to get

Select sum sum with fuzzy query How do I get it?
This post was last edited by Hackol on 2014-05-12 23:39:33

$sql = "Select Username,sum (IF (types = 1, Smoney, 0)) as T1 from record where 1=1". $s 1. " GROUP by username ";
The result now is that the sum of the Smoney fields of username = Username in the record table = 1 is assigned a variable $t 1
I'd like to change the query criteria
Hopefully the result is: the sum of the types field in the Record table username = username and the Smoney field with Nameuser in the regfrom field = 1 is assigned a variable $t 1

How to write the SQL statement. Database:
------Solution--------------------

$sql = "Select Username, SUM (Smoney) as T1 from record where username= ' $usename ' or InStr (Regfrom, ' $username ') >0";

