CODEWITHSUNDEEP
mysqlsqlsql-like
John Doee
John Doee

Reputation: 217

MySQL Workbench. How to have multiple conditions using LIKE, OR, AND

Is there any way to split up the expressions using the Like,OR, and AND operators. I am trying to use parenthesis to split my expressions, but I either get "Truncated incorrect DOUBLE value" or "Truncated incorrect INTEGER value" errors.

I want to have my statement to be almost set up like this,

((statement LIKE (This or This)

AND statement LIKE This))

OR statement LIKE this

DELETE FROM ap.vendor_contacts 
WHERE
    ((last_name LIKE 'd%' OR '%s')
    AND first_name LIKE 'm%')
    OR first_name LIKE '%al%'

Upvotes: 2

Views: 1287

Answers (1)

Madhur Bhaiya
Madhur Bhaiya

Reputation: 28844

You have a Syntax error. You cannot use LIKE operator as: <fieldname> LIKE <value1> OR <value2>. It has to be as follows:

<fieldname> LIKE <value1> OR <fieldname> LIKE <value2>

Do the following instead:

DELETE FROM ap.vendor_contacts 
WHERE
    ((last_name LIKE 'd%' OR last_name LIKE '%s')
    AND first_name LIKE 'm%')
    OR first_name LIKE '%al%'

Upvotes: 1

Related Questions