/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 vote167 views1 answer
Create dabase postgresql
SQL
0 vote160 views2 answers
Replace null with 0 in sql
SQL
3 votes154 views2 answers
Install mysql powershell
SQL
2 votes131 views2 answers
Get all columns from table sql
SQL
0 vote156 views1 answer
Difference between 2 query results sql server
SQL
0 vote172 views1 answer
How to combine rows in sql server procedure
SQL
0 vote151 views1 answer
Database get 10 user aleatory
SQL
0 vote143 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote142 views1 answer
Cross apply top for each row t1
SQL
1 vote142 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL

Share