SQL query to exclude values beginning with '1' in a specific column

Question

question

jenny asked Apr 18, '24 jenny commented Apr 19, '24

SQL query to exclude values beginning with '1' in a specific column

Hi,

I want to select rows that doesn't not begin with '1' in a specific column, but it seems not to work, and an error message popped up.

" Table.query("SELECT * FROM Test WHERE `A` not like '1%'"); "

How should I do? Thanks in advance!

0418.fsm

Software Version:

FlexSim 24.0.3

sql query table.query

error-message.png (26.4 KiB)

0418.fsm (26.0 KiB)

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Answer 1 · 2024-04-18T08:37:40Z

Joerg Vogel answered Apr 18, '24 jenny commented Apr 19, '24

A LIKE '[0,2-9]%'

inverse clause NOT doesn't seem to work with clause of LIKE in FlexSim. I tried it with an regular expression what is allowed and excluded 1 [0,2-9]

· 3

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Felix Möhlmann commented · Apr 18 at 08:46 AM

It works if the LIKE expression is enclosed in parentheses and the NOT is placed in front of it.

Table.query("SELECT * FROM Test WHERE NOT ([A] LIKE '1%')")

1 ·

jenny Felix Möhlmann commented · Apr 19 at 05:05 AM

Thanks a lot for your response.

0 ·

jenny commented · Apr 18 at 08:58 AM

Hi Joerg,

Thanks a lot for your response, your suggestions are very helpful. However I would like to ask if there is a possibility to support the query of 'not like' in the future?

0 ·

question