/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 vote186 views1 answer
ORA-00942
SQL
2 votes117 views1 answer
Columns Present in a table
SQL
0 vote125 views1 answer
Mysql Like(searching in the string)
SQL
0 vote69 views1 answer
'0000-00-00' for column '
SQL
0 vote111 views1 answer
Postgresql create user roles
SQL
5 votes123 views3 answers
Truncate function in sql oracle
SQL
0 vote117 views1 answer
Sql query to delete row by id
SQL
0 vote78 views1 answer
Mysql workbench search all tables
SQL
1 vote166 views1 answer
Sql server delete top 1000
SQL
1 vote109 views1 answer
Mysql how to reset primary key
SQL

Share