Reverse to contains/icontains

[kagamir]

In this question was solved problem for reverse LIKE operation in SQL, for example if field name is "Peter Johnson", we could find it by such query:

select name from user where "Mr. Peter Johnson" like CONCAT('%', name, '%')

Is there any way to do such thing in tortoise?

[long2ice]

await User.annotate(name=Concat(...)).fiter(name__contains='xxx')

[kagamir]

Thanks reply.

User.annotate(cname=Concat("name")).fiter(cname__contains="Mr. Peter Johnson").sql()

its returns:

SELECT `name`, CONCAT(`name`) `cname` FROM `user` WHERE CAST(CONCAT(`name`) AS CHAR) LIKE '%Mr. Peter Johnson%'

It finds who contains this string("Mr. Peter Johnson"). However, I want a name that appears inside a string. The string should be to the left of LIKE i think.

[long2ice]

Try use source_field in field because Mr. Peter Johnson is invalid python val