Using variable in trigger

[computerzworld]

Hello,
I am having a trigger in which I am using a variable which contains mobile number and I want to use it in query in the same trigger. Here is the syntax which I have used.

@CLSBYID = (SELECT userId FROM MST_USERS WHERE mobileNo like "%@MOBI%" AND companyId = '1' LIMIT 1);

It will return null even though @MOBI have a value and it is also stored in database. So what I should to use in order to get result? Please help me. Thanks in advance.

[Lars_Berg]

SELECT userId 
  FROM MST_USERS 
 WHERE mobileNo like concat('%',@MOBI,'%')
   AND companyId = 1 
 LIMIT 1