/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

7 votes186 views1 answer
Postgres base size
SQL
0 vote195 views1 answer
Create bdd mysql
SQL
13 votes179 views6 answers
Mysql update from select
SQL
2 votes230 views1 answer
Remove foreign key constraints in postgres
SQL
0 vote188 views1 answer
Drop all triggers oracle
SQL
0 vote180 views1 answer
2020 new year
SQL
0 vote191 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote235 views1 answer
SQL get max per id
SQL
0 vote199 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
1 vote145 views1 answer
Oracle boolean to varchar
SQL

Share