/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 vote119 views1 answer
Postgres dump sql insert
SQL
4 votes147 views4 answers
Remove duplicate old value in mysql
SQL
0 vote118 views1 answer
Sqlalchemy get ids
SQL
0 vote135 views1 answer
Find how many tables in database sql query
SQL
0 vote129 views1 answer
Sqlite select split string
SQL
4 votes117 views2 answers
Truncate oracle
SQL
0 vote119 views1 answer
Test database for sql
SQL
0 vote131 views2 answers
Coursera spark sql max count
SQL
2 votes113 views2 answers
Sql first character
SQL
0 vote114 views1 answer
Oracle running queries sql
SQL

Share