/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

1 vote361 views4 answers
Sql now
SQL
0 vote359 views1 answer
Mysql count unique in group statement
SQL
20 votes343 views2 answers
Mysql bigint max value
SQL
0 vote345 views1 answer
Datagrip exec
SQL
0 vote367 views1 answer
Kill mysqld_safe process mariadb
SQL
2 votes365 views1 answer
Oracle run_duration average
SQL
0 vote360 views1 answer
SQL Server rename foreign key constraint
SQL
0 vote399 views1 answer
Error code 1451 sql
SQL
0 vote361 views1 answer
Sql select random procentage from rows
SQL
4 votes364 views2 answers
Sql server date now
SQL

Share