/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 vote255 views1 answer
T-sql check if data exists
SQL
2 votes253 views1 answer
No data found oracle
SQL
14 votes268 views3 answers
Delete all records from table except sql
SQL
0 vote287 views1 answer
How can I tell how many Cores SQL Server is actually using?
SQL
0 vote277 views1 answer
T-sql email validation
SQL
2 votes251 views6 answers
In in sql
SQL
1 vote269 views1 answer
Window function mysql
SQL
7 votes253 views2 answers
Add column table pl sql
SQL
-1 vote268 views5 answers
Not in sql
SQL
1 vote261 views1 answer
Postgresql delete cascade
SQL

Share