/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 vote229 views1 answer
How to get alternate records from a table in sql
SQL
1 vote204 views1 answer
OSError: mysql_config not found
SQL
1 vote182 views1 answer
How to print longest name in sql
SQL
2 votes164 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote212 views1 answer
How to print some string in mysql
SQL
14 votes1.2K views1 answer
Sql value of string
SQL
0 vote172 views1 answer
Sql last 7 days
SQL
1 vote183 views1 answer
How to copy data of a table from another database to table of anaother database
SQL
0 vote237 views1 answer
Selecting specific day in colum sql
SQL
2 votes168 views3 answers
Write sql query to find the second highest salary of employee
SQL

Share