Forum Discussion

Shivshankar's avatar
Shivshankar
Ace
8 years ago

Like query in LiQL

Hi !   I am trying to fetch subject of all messages in particular board with certain keyword , formed this LiQL query   SELECT id,subject FROM messages WHERE board.id = '4' and subject MATCHES 'B...
  • VikasB's avatar
    VikasB
    8 years ago

    Hi srujanayeruvaka  
    Did you notice it would not work if you are not using the braces surrounding to the text which RobertT missed in their post?  But it works fine with braces.

    SELECT * FROM messages WHERE board.id = 'XYZ' and subject MATCHES ('batch*')

    Shivshankar  have a look, it really works.

srujanayeruvaka's avatar
srujanayeruvaka
Champion
4 years ago

Hi sh030348 - Matches keyword sometimes doesn't work as expected. I would suggest you to file a support case with Khoros and report your use case.