/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 vote213 views1 answer
Implode in sql query
SQL
3 votes187 views2 answers
Oracle privileges users
SQL
4 votes167 views1 answer
Wilayah indonesia database
SQL
0 vote194 views1 answer
Dump only data
SQL
6 votes186 views2 answers
Mysql version check cmd
SQL
0 vote189 views3 answers
Magento 2 order delete from db
SQL
0 vote177 views1 answer
Mysql replication change database name
SQL
0 vote186 views1 answer
Mysql command line ubuntu
SQL
0 vote188 views1 answer
Turn on foreign keys check mysql
SQL
13 votes167 views3 answers
Uninstall mysql centos 7
SQL

Share