/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 vote89 views1 answer
Output to file mysql
SQL
0 vote62 views2 answers
Sql query unique
SQL
0 vote115 views1 answer
Sql remove non numeric characters
SQL
0 vote108 views2 answers
Laravel: customize or extend notifications - database model
SQL
-1 vote98 views2 answers
Get day in sql
SQL
2 votes238 views1 answer
Set auto increment from 1
SQL
4 votes81 views1 answer
Sql list users and roles
SQL
1 vote116 views1 answer
Insert pg result of select
SQL
0 vote106 views1 answer
Oracle swap partition
SQL
8 votes115 views1 answer
Mysql restore database
SQL

Share