/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

-1 vote384 views5 answers
Left join
SQL
0 vote301 views1 answer
Postgresql add leading zeros
SQL
0 vote370 views1 answer
MySQL import data from large CSV file
SQL
10 votes382 views2 answers
SQL rounding numbers
SQL
0 vote367 views1 answer
Creating a simple notify in postgresql
SQL
0 vote371 views1 answer
Mysql min value row
SQL
1 vote369 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
1 vote345 views1 answer
Oracle create program if no exists
SQL
0 vote311 views1 answer
Sqlalchemy filter relationship
SQL
1 vote368 views1 answer
Mariadb case switch
SQL

Share