Fetch datas from mysql where column value contains two strings

Question

I want to search in mysql database with columns containing some supplier names and it has values like. Bansbach GmbH (default) , Bansbach Feinmechanik and Bansbach xyzsomething. I need to get the result as an array where it contains results with columns containing exactly equal to Bansbach if not then check for both Bansbach and default. How to write a mysql query like this.

Now I've tried some thing like this.[only my where clause included here]

WHERE suppliername ='Bansbach'

I need some thing like

 WHERE if(suppliername !='Bansbach' then (check it contains both bansbach and default)

Eugen Rieck · Accepted Answer · 2015-01-09 06:32:59Z

2

Plain regular SQL:

SELECT
  -- blah
FROM
  -- blah
WHERE
  suppliername = 'Bansbach'
  OR (
    suppliername LIKE '%Bansbach%'
    AND suppliername LIKE '%default%'
  )
;

EDIT

Why is this the same thing?

the OR branch will only ever be taken, if the first condition fails, this replaces you IF
"Containing both" is the same as "contain one AND contain the other"

answered Jan 9, 2015 at 6:32

Eugen Rieck

65.6k10 gold badges75 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hoja Over a year ago

Thanks for your answer. can I use NOT LIKE '%not use%'

v2solutions.com · Accepted Answer · 2015-01-09 06:40:28Z

0

Below sql should do a job for you:

SELECT
  suppliername
FROM
  [TABLE NAME]
WHERE
  suppliername = 'Bansbach' OR (suppliername LIKE '%Bansbach%' AND suppliername LIKE '%default%')

answered Jan 9, 2015 at 6:40

v2solutions.com

1,4399 silver badges8 bronze badges

Collectives™ on Stack Overflow

Fetch datas from mysql where column value contains two strings

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related