/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

0 vote362 views1 answer
Doesn't have default value mysql
SQL
0 vote321 views1 answer
No suitable driver found for sqlite
SQL
6 votes351 views2 answers
Mysql concatenate two columns into one
SQL
0 vote320 views1 answer
Restore backupfile discourse
SQL
5 votes330 views6 answers
Sql foreign key
SQL
3 votes324 views1 answer
Oracle show trigger code
SQL
1 vote320 views1 answer
Add current timestamp in mysql
SQL
18 votes318 views6 answers
Mysql create table
SQL
2 votes283 views1 answer
Oracle sql drop column if exists
SQL
5 votes283 views1 answer
Alter table default value mysql
SQL

Share