/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

14 votes297 views4 answers
Import database through command line
SQL
11 votes257 views2 answers
Having keyword sql
SQL
0 vote281 views1 answer
Into operator in sql
SQL
3 votes267 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote258 views1 answer
How to save data in database in mysql node
SQL
0 vote360 views1 answer
Mysql show schema
SQL
10 votes259 views4 answers
Primary key sql
SQL
0 vote273 views1 answer
Shell script to log mysql cpu usage
SQL
0 vote272 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
4 votes265 views2 answers
Mysql show indexes on table
SQL

Share