/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 vote261 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote261 views1 answer
View to table
SQL
11 votes253 views2 answers
Sql rank
SQL
1 vote274 views1 answer
Sql first day quarter
SQL
2 votes259 views2 answers
Compare date mysql
SQL
0 vote291 views1 answer
T-sql update table variale
SQL
0 vote257 views1 answer
In mysql workbench contnent not feching
SQL
3 votes270 views1 answer
Sql is not like
SQL
0 vote298 views2 answers
Mysql insert into multiple tables
SQL
1 vote229 views1 answer
Insert into sql
SQL

Share