/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 vote161 views1 answer
Mysql join only one column
SQL
1 vote274 views1 answer
Sql check roles
SQL
0 vote144 views1 answer
Min varias colunas spark sql
SQL
1 vote130 views1 answer
Scaffold mysql database
SQL
0 vote154 views2 answers
Transaction php
SQL
0 vote144 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL
7 votes263 views2 answers
Drop index oracle
SQL
1 vote91 views1 answer
Python escape string for sql
SQL
1 vote161 views1 answer
Count of tables in database mysql
SQL
0 vote137 views2 answers
Sql query inner join 3 tables
SQL

Share