php mysql query issue

Question

here's my table:

enter image description here

and I want get the customers which have some values of for/category fields which is comma separated..

I am trying something like this:

SELECT * FROM `customers` WHERE `for` LIKE ('%AMC PHD & WWS%' OR '%Rostfrei%' OR '%Thermopac%')

but its giving empty result.

dtbarne · Accepted Answer · 2011-05-25 19:31:55Z

4

RedFilter's SQL is correct, but you should also know that "for" is a MySQL reserved word. You should avoid using it as a column name, or wrap it in backticks when you use it:

SELECT * 
FROM customers 
WHERE `for` LIKE '%AMC PHD & WWS%'
    OR `for` LIKE '%Rostfrei%'
    OR `for` LIKE '%Thermopac%';

The alternative, typing the column name once is:

SELECT * FROM customers WHERE `for` REGEXP 'AMC PHD \& WWS|Rostfrei|Thermopac';

answered May 25, 2011 at 19:31

dtbarne

8,2505 gold badges47 silver badges49 bronze badges

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

Comments

D'Arcy Rittich · Accepted Answer · 2011-05-25 19:29:17Z

3

Try:

SELECT * 
FROM customers 
WHERE for LIKE '%AMC PHD & WWS%'
    or for LIKE '%Rostfrei%'
    or for LIKE '%Thermopac%'

answered May 25, 2011 at 19:29

D'Arcy Rittich

172k41 gold badges298 silver badges287 bronze badges

1 Comment

Vaibhav Gupta Over a year ago

it seems to be working.. but is there any way so that I don't have to write field name again and again..?

Collectives™ on Stack Overflow

php mysql query issue

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related