How to search multiple values at once in phpMyAdmin?

Question

I have a database search question. I am useless with databases but I know how to search for one item at a time in my website's database; I just put in the item code (e.g. `wk660`) on the `pd_code` field line in the phpMyAdmin search page, but I don't know how to search for more than one item in a single search.

I want to search for *several items* in one search, using more than one item code at a time. I tried: `wk660 OR wk30 OR wk483` to search for three at the same time for the field but it didn't find anything, although all three can be found if I do them one at a time.

I also tried separating them with `AND` and I tried enclosing the product codes in `%%`.  None worked. My Google searches haven't helped me find how to do it. Can you tell me what I should put in to search for several items in one search, please?

There is a screenshot below of the *phpMyAdmin* search page to show what I mean. The line I put the item code (what I am searching) into is the `pd_code` field, you can see one item code in it in the picture:

![phpMyAdmin Search Database Table](https://cdn.ozzu.com/uploads/1/post/585664/1/searchdatabase.jpg)

Accepted Answer

From the pulldown menu instead of choosing _LIKE_, choose _REGEXP_. Then for the value separate each thing you are searching for with a pipe symbol, which is `|`. So for instance you would put this for the value in the phpMyAdmin field box for *pd_code*:

```
wk660|wk30|wk483
```

Let me know if that does the trick 🙂

cerio

2 Answers

Brian Wozeniak

Your Answer

User

Community

Market

Help Center

Legal

Company

Social Media