/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 vote208 views1 answer
Alter table change default
SQL
0 vote251 views1 answer
Select multiple row from primary key sql
SQL
3 votes180 views2 answers
Oracle sql select all days between two dates except weekends
SQL
0 vote254 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote229 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
0 vote193 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote361 views1 answer
Current month transactions in mysql
SQL
0 vote204 views1 answer
Mysql workbench primary key
SQL
1 vote255 views1 answer
Encrypt password postgresql
SQL
0 vote276 views1 answer
Mysql extract day from date leading zero
SQL

Share