/SQL/Mysql SELECT

Mysql SELECT

How to select all attributes from a row if there is a certain string in it MySQL

SELECT column1, column2,...
FROM table_name
WHERE first_name = 'John' AND sales_in_year <= 50

1

Mysql SELECT

SELECT 
  `nachname` , `vorname` 
FROM testadressen
WHERE vorname = 'Fischer'

0

Source: php-kurs.com

Similar codes

3 votes221 views2 answers
Postgresql select all column names
SQL
16 votes236 views2 answers
Mysql date between two dates
SQL
0 vote247 views1 answer
Mysql get first 2 characters of string
SQL
0 vote221 views2 answers
Many to many flask-sqlalchemy
SQL
1 vote241 views1 answer
Postgres see sequence current state
SQL
0 vote207 views1 answer
Mysql autoincrement valor inicial
SQL
16 votes219 views4 answers
Sort by sql
SQL
0 vote179 views2 answers
Delete the last item in a table sql
SQL
0 vote221 views1 answer
Foreign key multiple columns
SQL
0 vote244 views5 answers
How to make trigger in phpmyadmin
SQL

Share