A
A
Alexey selftrips.ru2019-02-23 16:19:42
SQL
Alexey selftrips.ru, 2019-02-23 16:19:42

How to select records whose field does not contain param1 or param2?

How to modify the request so that the output does not 'option_name'contain param1 or param2

SELECT * FROM `wp_options` WHERE `option_name` LIKE '%mmp%'

Answer the question

In order to leave comments, you need to log in

1 answer(s)
K
Konstantin Tsvetkov, 2019-02-23
@tsklab

WHERE `option_name` NOT LIKE '%param1%' AND `option_name` NOT LIKE '%param2%'

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question