How to search multiple values at once in phpMyAdmin?

You're on the right track! phpMyAdmin allows searching for multiple items in a single search using the IN operator. Here's how to achieve what you want:

1. Use the IN operator: Instead of OR or commas, separate your item codes with commas and enclose them within parentheses after IN. For example:

SELECT * FROM your_table WHERE pd_code IN ('wk660', 'wk30', 'wk483');

This query searches the your_table table for rows where the pd_code field value is either wk660, wk30, or wk483.

1. Replace your_table: Make sure to replace your_table with the actual name of the table containing your product data (e.g., products).

2. Consider Wildcards (Optional): If your item codes share a pattern (e.g., starting with "wk"), you can use wildcards with LIKE instead of IN. However, this might be less efficient for a large number of item codes.

Remember:

• Escape special characters in your item codes if they contain things like apostrophes or backslashes. This helps prevent unexpected behavior in the query.
• Make sure you're searching the correct field. In your example, it seems like pd_code is the field containing item codes.

By following these steps, you should be able to search for multiple items in your phpMyAdmin search and see results for all three product codes in one go.