Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>That isn't really the way SQL works. You can get some of that same functionality, but it won't look anything like what you are asking; you are writing (naturally enough) in a more procedural style.</p> <p>For one thing "add results" is trying to bring (presumably) disparate things together into a single collection. You are - I think - asking for restaurants and cuisines and cities and postcodes all to go into the same collection, and the only kind of collection SQL has (roughly speaking) is tables, and within a table, all rows have the same type. </p> <p>But maybe restaurants and cuisine and city and postcode are all fields of the same table? Well, then, for a given word you could say</p> <pre><code>SELECT * FROM your_table WHERE restaurant like "%" + word + "%" OR cuisine like "%" + word + "%" OR city like "%" + word + "%" OR postcode like "%" + word + "%"; </code></pre> <p>It starts to get complicated when you want to match multiple words; this answer is intended as a starting point; maybe once you're more familiar with SQL you can ask easier-to-answer questions. Good luck!</p> <p><strong>Update</strong> based on your table descriptions</p> <pre><code>SELECT r.* FROM restaurant r INNER JOIN link k ON k.restaurant_id = r.restaurant_id INNER JOIN cuisine c on c.cuisine_id = k.cuisine_id WHERE r.restaurant like "%" + word + "%" OR c.name like "%" + word + "%" OR r.city like "%" + word + "%" OR r.postcode like "%" + word + "%"; </code></pre> <p>And don't worry about which records come back "first". Your database will be fast enough that that should not be a concern.</p>
    singulars
    1. This table or related slice is empty.
    1. POSQL Algorithm Trouble - for loop to add and filter results
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCarl Manaster
    1. USCarl Manaster
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThat is somethign similar to what I had before but the thing I am trying to do is match multiple words inputed in any order. Hence the order of my if statements in my pseudo code. Cuisine is the only field in a different tabe as it is linked through another table as a restaurant can serve many types of cuisine
      singulars
      1. PO
      1. USddd
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload