/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 vote145 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
0 vote142 views1 answer
C# mysql data reader from two tables
SQL
4 votes176 views4 answers
Mysql get date from datetime
SQL
0 vote153 views1 answer
Mysql set variable to today's date
SQL
0 vote139 views1 answer
Tsql generate rows
SQL
2 votes151 views1 answer
Enum in SQL Server
SQL
3 votes153 views2 answers
Truncate all tables
SQL
13 votes189 views2 answers
Sqlite rename table
SQL
0 vote189 views5 answers
Select concat alter table mysql
SQL
0 vote177 views1 answer
SQL SERVER xquery count child nodes
SQL

Share