[mysql] Import data by selecting only specific column values

Asked 2 years ago, Updated 2 years ago, 34 views

Hi, how are you?

I'm implementing a web page using node

As above, I want to select a record when it is a data value called health common sense in a column called category

I'm not sure which way to choose.

select * from table name order by view limit 5;

I know you're bringing the record with the most views in this way, but I don't know how to do it above ㅠ<

Help!

mysql

2022-09-21 17:39

1 Answers

select * from table name where category = 'health common sense';

Where clause is a conditional clause.

There are some grammatical differences between vendors, but they are generally the same.

If you don't feel uncomfortable with English, please take a look at the tutorial below.

Standard SQL Tutorial

MySQL tutorial


2022-09-21 17:39

If you have any answers or tips


© 2024 OneMinuteCode. All rights reserved.