User Account Correlation rule is not working

[rama_roy]

I have configured the correlation rule in SQL format but while importing it is not correlating Account with User.
In our case, Account name could be same as user name or it will be having numeric digit or digit and alphabet both at the end.
Eg.
Username: r1234r
Account Name: r1234r2 / 31234r2d

Using the below correlation rule to achieve this. But it seems not working. Please let me know if the format is wrong or what changes I have to do.

a.name LIKE CONCAT(u.username,'%')

Another question, if I want to test for one user. Will the below format work?

a.name LIKE CONCAT(u.username,'%') and u.username='r1234r'

Regards,
Rama

[Raghu]

Can you give what format expecting after co-relation

Username: r1234r
Account Name: r1234r2 / 31234r2d

result: ?

[rushikeshvartak]

You can't test for one user 

users.username =a.name LIKE CONCAT(u.username,'%')

[rama_roy]

Hi,

The above mention query is not working. I tried the query in data analyzer and it is giving the wrong output.
Getting correct output in data analyzer when using only accounts.name LIKE CONCAT(users.username,'%')

sample Data 
Username: r1234r
Account Name: r1234r2 and 31234r2d
Expected Result:
Both the account should be correlated with the Username. So While searching for users, both the account should be present under Account tab.

Regards,
Rama