Use FlySpeed SQL Query to generate and test your queries
- Label
- Label displayed next to the drop-down list.
Example : "Author"
- Value(s)
- Fields to be displayed in the drop-down list, separated by "+".
Example : "authors.name + authors.first_name"
- Fields
- Fields for the query SQL SELECT.
Example : "authors.name, authors.first_name, articles.authors_id"
- Fields to be filtered
- The field used to filter the query.
Example : "articles.authors_id"
- SQL FROM
- SQL FROM query.
Example : "articles Left Join authors On articles.authors_id = authors.id"
- Type of values
- Text or Boolean.
The query cited as an example will be the following :
SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id
When the user has chosen an item from the list :
SELECT DISTINCT authors.name, authors.first_name, articles.authors_id FROM articles INNER JOIN authors ON articles.authors_id = authors.id WHERE articles.authors_id = [posted value]