我无法在phalcon的集合中查询％like

Question

I use phalcon with mongo db. Model is Collection. I want use find to get

SELECT * FROM Users WHERE Username LIKE '%TienNguyen%'

I see in mongo db have query

b.users.find(
      { Username: /TienNguyen/ }
)

But in collection of Phalcon. How do I code it.

I tried Users::find([['Username' => "/TienNguyen/"]]); It is not working.

Please help me

Answer 1

As was mentioned above, regex searches that are not anchored at the beginning of the string can be very expensive because they require a full table scan. Depending on your use case you might consider using a text index instead. It provides support for case-insensitive non-anchored searches including suffix stemming.