/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 vote276 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
1 vote239 views1 answer
Check if mysql is installed
SQL
0 vote231 views1 answer
Oracle job session
SQL
0 vote213 views1 answer
Alter session set nls_language french
SQL
0 vote227 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
0 vote227 views1 answer
Oracle flush Shared Pool
SQL
0 vote207 views1 answer
Get number of table colums in sql query
SQL
0 vote239 views1 answer
SQL Server Enterprise
SQL
3 votes222 views1 answer
What is having clause
SQL
0 vote237 views1 answer
C# check if mysql query modified rows
SQL

Share