Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

SQL queries cleaner better in jquery

Manoj Bhatt 2289 06 Nov 2014

I have something like this:

SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 4 LIMIT 1;
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 24 LIMIT 1;
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 29 LIMIT 1;

If will be more queries it will be very long. How do this in the other way, in one line? But important is for me speed. cars.brand = X AND LIMIT X is a variable so it maybe changes.

1 Answers

Anonymous User 06 Nov 2014

You are worried about having to send so many queries one by one, so that would take a lot of time. You can make this one query instead:

SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 4 LIMIT 1
UNION ALL
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 24 LIMIT 1
UNION ALL
SELECT cars.brand, cars.id FROM cars WHERE cars.brand = 29 LIMIT 1;

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.