From the course: Learning phpMyAdmin

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Using QBE to set multiple conditions in a WHERE clause

Using QBE to set multiple conditions in a WHERE clause

From the course: Learning phpMyAdmin

Start my 1-month free trial

Using QBE to set multiple conditions in a WHERE clause

“

- The Query tab allows you to build complex Queries by Example. The tab is visible only when you have a database selected in phpMyAdmin. So let's select the up_and_running database. The Query tab is the fourth tab from the left at the top. But if you've got an individual table selected, let's say I've got the cars table selected, that Query tab then disappears. So if you use Query by Example, you must be at the database level so let's go back up to database up_and_running and then select the Query tab. There's an invitation at the top to switch to a visual builder. In my experience, the visual builder is not at all reliable. I much prefer using the form-based interface so that's what we'll do. When you first open the Query tab, all of the options in here can be a little bit overwhelming so let's take a quick tour of what we've got. By default, the form displays fields for three columns and you also got two rows for Criteria, in other words, conditions that you want to add to a WHERE…

Contents