sql - 等同于XQuery中的like？(Equivalent to like in XQuery?)

Question

I am trying to get all titles that contain a certain word from my database in XQuery in SQL I would use WHERE title LIKE '%England%' - I am wondering how to do this in XQuery?

(我正在尝试从SQL的XQuery数据库中获取包含某个单词的所有标题，而我会使用WHERE title LIKE '%England%' -我想知道如何在XQuery中做到这一点？)

My XQuery query looks like this:

(我的XQuery查询如下所示：)

(:Selects document:)
for $x in doc ("tmdb_5000_movies(1).xml")/movies/movie 
(: :)
where $x/title (:NOT SURE WHAT TO PUT HERE:)
(:0:)
return $x/ *

  ask by BradleighJL translate from so

Answer 1

This does it.

(做到了。)

for $x in doc ("tmdb_5000_movies(1).xml")/movies/movie [matches(title, '.*England')] 

return $x/ *

Much prefer SQL, However, I can see why this is the future

(我更喜欢SQL，但是我可以看到为什么这是未来)