/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 vote190 views1 answer
Value of sold product using having and group by in sql
SQL
7 votes222 views1 answer
Show line number in sql server
SQL
6 votes198 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
8 votes185 views3 answers
Connect python to mysql
SQL
4 votes198 views3 answers
Count with where
SQL
2 votes211 views1 answer
Oracle trace file
SQL
0 vote185 views1 answer
Sql list dates between two dates
SQL
1 vote180 views1 answer
Sql drop with dependencies
SQL
3 votes227 views1 answer
Mysql cli connect with password
SQL
22 votes188 views4 answers
Mysql date_format
SQL

Share