/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 vote253 views1 answer
Update row in sqlite python
SQL
1 vote308 views1 answer
T-sql find object by name
SQL
1 vote280 views1 answer
Oracle case
SQL
0 vote292 views1 answer
Show table details postgresql
SQL
0 vote285 views1 answer
Android sqlite get rows count
SQL
3 votes289 views1 answer
Select database in sql
SQL
0 vote341 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
4 votes268 views2 answers
How to delete row in sql
SQL
-1 vote290 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote312 views1 answer
Dropping a constraint in ms sql
SQL

Share