XPath notepad ('like' queries)

Nothing fancy in this post, I just don't want to forget how to do 'like' queries in xpath

XPath: //category[@name='abc']

is equivalent to

Sql: select * from category where name ='abc'

XPath: //category[contains(@name, 'abc')]

is equivalent to

Sql: select * from category where name like '%abc%'