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

Ah VikasB! got it. Thank you for this information :). Here is the corrected query and it worked just fine for me.

 

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

 

I created 2 topics with subjects as 'First Test Topic' and 'Second testtopic' and the above query returned both.

 

Shivshankar - Can you try this query?

 

VikasB's avatar
VikasB
Boss
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
    8 years ago

    Yes I did, thanks to you for pointing that out VikasB! :)