S
S
Sergey2021-02-12 17:25:47
MySQL
Sergey, 2021-02-12 17:25:47

How can I enumerate a list of stop words in SQL that I don't want to sample?

Good afternoon.

I have stop words that should not be in the sample, tell me how can I write them more correctly?

My code:
AND uf_brand_name NOT LIKE '%®%'

I don't want to do a lot of AND and write such strings, tell me how can I list such characters in a string?

Thank you!

Answer the question

In order to leave comments, you need to log in

1 answer(s)
B
BorLaze, 2021-02-13
@BorLaze

Something like this:

SELECT * FROM table WHERE field NOT REGEXP '.*®.*|.*™.*';

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question