Basic Searching Using PhpMyAdmin

PhpMyAdmin is a useful web-based tool which allows you to perform a range of database actions, typically on a MySQL database. Although it can be a bit clunky, it is nonetheless powerful and it’s one of those features that I want to talk about today: searching.

This isn’t an exhaustive list of the myriad ways you can hunt for things in your database; it’s a simple couple of examples, but hopefully it will be specifically useful if you are searching for more than one possible item in a field. OK, let’s get nosey!

A basic search

Firstly, once logged into the admin console and having clicked on a database and table on the left (let’s hope you can get that far), click on the search tab at the top.

The Search tab

The Search tab

I can’t access your database (of course!) so from here on in, we’re going to be using mine, but you can easily adapt things.

We’re going to begin by searching one field. Here I’ve clicked onto the empty box alongside my “first_name” field, and typed “Stephen” (without the quotes).

Searching using one field

Searching using one field

Somewhere down the bottom right of the window (you may have to scroll down), you will find the “Go” button – that’s what you click on to make the search start. When I do that, I get these results:

Search results - my name appears.

Search results

Easy, right? Just by typing in the thing you are looking for, you can search that field for that (exact) item. What if we want to filter based on more than one field?

Searching for more than one (different) item in multiple fields

To base your criteria on two fields, just type in two values in the specific two places. I am keeping things simple and using the “last_name” field, too.

Searching based on two fields

Searching based on two fields

Again, click on “Go” to make the search occur.

Searching based on partial information

How about a situation in which I think I know what I want, but I am not quite sure how it begins or ends? For that, you can search using the “% LIKE %” comparator. You can find that by accessing the drop down where you see “LIKE”, so let’s choose that.

Using wildcards to searchwith

Using two fields and one wildcard search

In this example, I am sure the name I am looking for contains the string “tephe” but I can’t remember the beginning or end (don’t laugh – you will be as old as me one day!). Again, I click “Go” and magically, my results re-appear.

Searching for more than one item in one field

That’s all pretty obvious but what if I want to search for two (or more) things, in one field? For instance, I might be searching for “Stephen” OR “Steven” in case the name is spelt differently. For this, we’re going to use what’s known as a regular expression and in particular, the pipe (“|”) symbol. It’s the one you get when you usually press shift-\ on your keyboard.

As shown, just type your two (or more options) separated by the pipe symbol and press “Go”.

Using a regular expression

Using a regular expression

There’s much, much more you can do with this (especially with regular expressions) but hopefully this will get you started.

twittergoogle_plusredditpinteresttumblrmail

Written by Stephen Moon
email: stephen at logicalmoon.com
www: https://www.logicalmoon.com


Leave a Reply

Your email address will not be published. Required fields are marked *